public DataTable Insert(tbl_company r) { DataTable result = null; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@company_name", r.company_name); parameters.Add("@first_name", r.first_name); parameters.Add("@last_name", r.last_name); parameters.Add("@owner_emailid", r.owner_emailid); parameters.Add("@owner_mobileno", r.owner_mobileno); parameters.Add("@country_id", r.country_id); parameters.Add("@company_zip", r.pincode); parameters.Add("@status", r.status); parameters.Add("@created_by", r.created_by); parameters.Add("@created_date", r.created_date); parameters.Add("@modified_by", r.modified_by); parameters.Add("@modified_date", r.modified_by); try { result = helper.GetDataTablebyProc(SP.RackInsert, parameters); } catch (Exception ex) { return(result); } return(result); }
public DataTable All12(tbl_company p) { DataTable programs = new DataTable(); try { Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@company_id", p.company_id); DataTable dt = helper.GetDataTableFromStoredProc(SP.selectcompanylogo, parameters); foreach (DataRow dr in dt.Rows) { string logoimg = (dr["logo"].ToString()); p.logo = (logoimg).ToString(); } programs = dt; } catch (Exception ex) { ErrorLog.saveerror(ex); } return(programs); }