public bool AddNewOrder_Master(Order_Master b1) { b1.Om_id = GetNewTBLID(); string sql = "insert into [Order_Master] ([Om_id],[Reg_id],[Mem_id],[Om_number],[Om_date],[Order_bill_no],[Ord_date],[Sup_name],[Sup_address],[Sup_city],[Sup_mobile],[Sup_email],[Gross_amt],[Dis_amt],[Net_amt],[Is_paid],[User1],[Status]) values(" + b1.Om_id + ", " + b1.Reg_id + ", " + b1.Mem_id + ", " + b1.Om_number + ", '" + b1.Om_date + "', " + b1.Order_bill_no + ", '" + b1.Ord_date + "', '" + b1.Sup_name + "', '" + b1.Sup_address + "', '" + b1.Sup_city + "', " + b1.Sup_mobile + ", '" + b1.Sup_email + "', " + b1.Gross_amt + ", " + b1.Dis_amt + ", " + b1.Net_amt + ", '" + b1.Is_paid + "', '" + b1.User1 + "', " + b1.Status + " )"; return(SqlDBHelper.ExecuteNonQuery(sql)); }
public List <Order_Master> GetOrder_MasterList() { string Sql = "select * from [Order_Master]"; List <Order_Master> listOrder_Master = null; //Lets get the list of all Order_Master in a datatable using (DataTable table = SqlDBHelper.ExecuteSelectCommand(Sql)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of Order_Master listOrder_Master = new List <Order_Master>(); //Now lets populate the Order_Master details into the list of Order_Master foreach (DataRow row in table.Rows) { Order_Master b1 = new Order_Master(); b1.Om_id = Convert.ToInt32(row["Om_id"]); b1.Reg_id = Convert.ToInt32(row["Reg_id"]); b1.Mem_id = Convert.ToInt32(row["Mem_id"]); b1.Om_number = Convert.ToInt32(row["Om_number"]); b1.Om_date = Convert.ToDateTime(row["Om_date"]); b1.Order_bill_no = Convert.ToInt32(row["Order_bill_no"]); b1.Ord_date = Convert.ToDateTime(row["Ord_date"]); b1.Sup_name = row["Sup_name"].ToString(); b1.Sup_address = row["Sup_address"].ToString(); b1.Sup_city = row["Sup_city"].ToString(); b1.Sup_mobile = Convert.ToDecimal(row["Sup_mobile"]); b1.Sup_email = row["Sup_email"].ToString(); b1.Gross_amt = Convert.ToDecimal(row["Gross_amt"]); b1.Dis_amt = Convert.ToDecimal(row["Dis_amt"]); b1.Net_amt = Convert.ToDecimal(row["Net_amt"]); b1.Is_paid = row["Is_paid"].ToString(); b1.User1 = row["User1"].ToString(); b1.Status = Convert.ToInt32(row["Status"]); listOrder_Master.Add(b1); } } } return(listOrder_Master); }
//////////////////////////// public Order_Master GetOrder_MasterDetails(int x1) { string Sql = "select * from [Order_Master] where [Om_id] =" + x1 + " "; Order_Master b1 = null; //Lets get the list of all employees in a datatable using (DataTable table = SqlDBHelper.ExecuteSelectCommand(Sql)) { //check if any record exist or not if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; //Lets go ahead and create the list of Order_Master b1 = new Order_Master(); //Now lets populate the employee details into the list of Order_Master b1.Om_id = Convert.ToInt32(row["Om_id"]); b1.Reg_id = Convert.ToInt32(row["Reg_id"]); b1.Mem_id = Convert.ToInt32(row["Mem_id"]); b1.Om_number = Convert.ToInt32(row["Om_number"]); b1.Om_date = Convert.ToDateTime(row["Om_date"]); b1.Order_bill_no = Convert.ToInt32(row["Order_bill_no"]); b1.Ord_date = Convert.ToDateTime(row["Ord_date"]); b1.Sup_name = row["Sup_name"].ToString(); b1.Sup_address = row["Sup_address"].ToString(); b1.Sup_city = row["Sup_city"].ToString(); b1.Sup_mobile = Convert.ToDecimal(row["Sup_mobile"]); b1.Sup_email = row["Sup_email"].ToString(); b1.Gross_amt = Convert.ToDecimal(row["Gross_amt"]); b1.Dis_amt = Convert.ToDecimal(row["Dis_amt"]); b1.Net_amt = Convert.ToDecimal(row["Net_amt"]); b1.Is_paid = row["Is_paid"].ToString(); b1.User1 = row["User1"].ToString(); b1.Status = Convert.ToInt32(row["Status"]); } } return(b1); }
//////////////////////////// public bool DeleteOrder_Master(Order_Master x1) { string Sql = "delete from [Order_Master] where [Om_id] =" + x1.Om_id + " "; return(SqlDBHelper.ExecuteNonQuery(Sql)); }
//////////////////////////// public bool UpdateOrder_Master(Order_Master b1) { string sql = "update [Order_Master] set [Reg_id]=" + b1.Reg_id + " ,[Mem_id]=" + b1.Mem_id + " ,[Om_number]=" + b1.Om_number + " ,[Om_date]='" + b1.Om_date + "',[Order_bill_no]=" + b1.Order_bill_no + " ,[Ord_date]='" + b1.Ord_date + "',[Sup_name]='" + b1.Sup_name + "',[Sup_address]='" + b1.Sup_address + "',[Sup_city]='" + b1.Sup_city + "',[Sup_mobile]=" + b1.Sup_mobile + " ,[Sup_email]='" + b1.Sup_email + "',[Gross_amt]=" + b1.Gross_amt + " ,[Dis_amt]=" + b1.Dis_amt + " ,[Net_amt]=" + b1.Net_amt + " ,[Is_paid]='" + b1.Is_paid + "',[User1]='" + b1.User1 + "',[Status]=" + b1.Status + " where [Om_id] =" + b1.Om_id + " "; return(SqlDBHelper.ExecuteNonQuery(sql)); }