namespace SendFile
{
public class File: IFile
{
public string Insert(string InsertDLog, string InstrValue)
{
string InsertXMl = Insert.ToString();
string Id = InstrValue.ToString();
DAL.InsertDB(Id,InsertXMl );
return null;
}
}
}
namespace SendFile
{
public static class DAL
{
public static void InsertDB(string Id , string InsertXMl )
{
string connection = ConfigurationManager.ConnectionStrings["DConnection"].ConnectionString;
string StoredProc = ConfigurationManager.AppSettings["Insert_Update"];
try
{
SqlConnection conn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand(StoredProc,conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = Id ;
cmd.Parameters.Add("@StatusID", SqlDbType.Int).Value = 1;
cmd.Parameters.Add("@Message", SqlDbType.Xml).Value = InsertXMl ;
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
}