public bool AddProspectPlan(clsProspect info) { int st = 0; try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_AddProspect")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@ProjectNo", info.ProjectNo); cmd.Parameters.AddWithValue("@Sector", info.Sector); cmd.Parameters.AddWithValue("@Unit", info.UPlot); cmd.Parameters.AddWithValue("@ProspectName", info.ProspectName); cmd.Parameters.AddWithValue("@ProspectFatherName", info.ProspectFatherName); cmd.Parameters.AddWithValue("@CNIC", info.CNIC); cmd.Parameters.AddWithValue("@ContactNo", info.ContactNo); cmd.Parameters.AddWithValue("@ProspectPaymentPlan", info.ProspectPaymentPlan); cmd.Parameters.AddWithValue("@SizeCode", info.SizeCode); cmd.Parameters.AddWithValue("@ProspectStartDate", info.ProspectStartDate); cmd.Parameters.AddWithValue("@UnitType", info.UnitType); cmd.Parameters.AddWithValue("@UnitCategory", info.UnitCategory); cmd.Parameters.AddWithValue("@UnitAdditionalChrg", info.UnitAdditionalChrg); cmd.Parameters.AddWithValue("@PlotPrice", info.PlotPrice); cmd.Parameters.AddWithValue("@PlotAdditionalCharges", info.PlotAdditionalCharges); cmd.Parameters.AddWithValue("@TotalPrice", info.TotalPrice); cmd.Parameters.AddWithValue("@Discount", info.Discount); cmd.Parameters.AddWithValue("@id", info.id); st = cmd.ExecuteNonQuery(); } } conn.Close(); } } catch (Exception ex) { } if (st > 0) { return(true); } else { return(false); } }
public List <clsProspect> GetAllProspects(string projectid, DateTime startdate, DateTime enddate) { List <clsProspect> lst = new List <clsProspect>(); using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("TMR_USP_GetProspect")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@projectid", projectid); cmd.Parameters.AddWithValue("@StartDate", startdate); cmd.Parameters.AddWithValue("@EndDate", enddate); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var info = new clsProspect(); info.ProjectNo = reader["ProjectNo"].ToString(); info.Sector = reader["Sector"].ToString(); info.UPlot = reader["Unit"].ToString(); info.ProspectName = reader["ProspectName"].ToString(); info.ProspectFatherName = reader["ProspectFatherName"].ToString(); info.CNIC = reader["CNIC"].ToString(); info.ContactNo = reader["ContactNo"].ToString(); info.ProspectPaymentPlan = reader["ProspectPaymentPlan"].ToString(); info.SizeCode = reader["SizeCode"].ToString(); info.ProspectStartDate = Convert.ToDateTime(reader["ProspectStartDate"].ToString()); info.UnitType = reader["UnitType"].ToString(); info.UnitCategory = reader["UnitCategory"].ToString(); info.UnitAdditionalChrg = Convert.ToDecimal(reader["UnitAdditionalChrg"]); info.PlotPrice = Convert.ToDecimal(reader["PlotPrice"]); info.PlotAdditionalCharges = Convert.ToDecimal(reader["PlotAdditionalCharges"]); info.TotalPrice = Convert.ToDecimal(reader["TotalPrice"]); info.Discount = Convert.ToDecimal(reader["Discount"]); info.id = Convert.ToInt32(reader["id"].ToString()); lst.Add(info); } conn.Close(); } } return(lst); }