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); }