public DataTable Insert(tbl_party r)
{
DataTable result = null;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@company_id", r.company_id);
parameters.Add("@branch_id", r.branch_id);
parameters.Add("@party_name", r.party_name);
parameters.Add("@party_address", r.party_address);
parameters.Add("@contact_no", r.contact_no);
parameters.Add("@gstin_no", r.gstin_no);
parameters.Add("@party_type", r.party_type);
parameters.Add("@status", r.status);
parameters.Add("@created_by", r.created_by);
parameters.Add("@created_date", r.created_date);
parameters.Add("@state_id", r.state_id);
try
{
result = helper.GetDataTablebyProc(SP.PartyInsert, parameters);
}
catch (Exception ex)
{
return(result);
}
return(result);
}
public DataTable All3(tbl_party p)
{
DataTable programs = new DataTable();
try
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@company_id ", p.company_id);
parameters.Add("@branch_id", p.branch_id);
parameters.Add("@party_id", p.party_id);
parameters.Add("@party_type", p.party_type);
DataTable dt = helper.GetDataTableFromStoredProc(SP.partyprint, parameters);
foreach (DataRow dr in dt.Rows)
{
p.party_name = (dr["party_name"].ToString());
p.party_address = (dr["party_address"].ToString());
p.contact_no = (dr["contact_no"].ToString());
}
programs = dt;
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(programs);
}