public DataSet GetDataSet(DO_DocumentList objDoCaseList, DocumentList flag)
{
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("scrl_AddEditDeleteCaseListDocument_SP", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@CaseId", SqlDbType.BigInt).Value = objDoCaseList.Caseid;
// da.SelectCommand.Parameters.Add("@AddedBy", SqlDbType.BigInt).Value = objDoCaseList.AddedBy;
da.SelectCommand.Parameters.Add("@ContentTypeId", SqlDbType.Int).Value = objDoCaseList.ContentTypeId;
da.Fill(ds);
co.CloseConnection(conn);
return(ds);
}
public void AddEditDel_CaseList(DO_DocumentList objcase, DA_DocumentList.DocumentList flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("scrl_AddEditDeleteCaseListDocument_SP", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@CaseId", SqlDbType.BigInt).Value = objcase.Caseid;
cmd.Parameters.Add("@StrContentTitle", SqlDbType.VarChar, 200).Value = objcase.ContentTitle;
cmd.Parameters.Add("@Citationid", SqlDbType.Int).Value = objcase.CitationId;
cmd.Parameters.Add("@ContentTypeId", SqlDbType.Int).Value = objcase.ContentTypeId;
cmd.Parameters.Add("@intuserid", SqlDbType.Int).Value = objcase.AddedBy;
cmd.ExecuteNonQuery();
co.CloseConnection(conn);
}