public int AddRecord(EventCFollowUpBLL objCFBLL) { int row; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); try { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@CID", objCFBLL.CID1), new SqlParameter("@Date", objCFBLL.Date1), new SqlParameter("@Remark", objCFBLL.Remark1), new SqlParameter("@Status", objCFBLL.Status1), new SqlParameter("@CurrentDate", cc.DateFormatStatus()), new SqlParameter("@UserId", objCFBLL.UserId1), }; SqlCommand cmd = new SqlCommand("EventCFollowUpInsert", con); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); con.Open(); row = cmd.ExecuteNonQuery(); return(row); } catch (Exception ex) { throw ex; } finally { con.Close(); } }
public DataSet LoadGrid(EventCFollowUpBLL objCFBLL) { try { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); SqlParameter[] par = new SqlParameter[1]; par[0] = new SqlParameter("@UserId", objCFBLL.UserId1); SqlCommand cmd = new SqlCommand("EventCFollowUpLoadgrid", con); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); return(ds); } catch (Exception ex) { throw ex; } }
public int AddrecordBLL(EventCFollowUpBLL objCFBLL) { int i = objCFDAL.AddRecord(objCFBLL); return(i); }
public DataSet LoadgridBLL(EventCFollowUpBLL objCFBLL) { return(objCFDAL.LoadGrid(objCFBLL)); }