public MST_School Update(SchoolQPaper_entities entities, int SCHL_id, string SCHL_code, string SCHL_name, string SCHL_address,
string SCHL_font, string SCHL_principal_name, string SCHL_principal_address, string SCHL_principal_tele,
int?AGENT_id, int?PROVINCE_id, int?ZONE_id, int?DIVISION_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_School school_rec = entities.MST_School.Find(SCHL_id);
school_rec.SCHL_code = SCHL_code;
school_rec.SCHL_name = SCHL_name;
school_rec.SCHL_address = SCHL_address;
school_rec.SCHL_font = SCHL_font;
school_rec.SCHL_principal_name = SCHL_principal_name;
school_rec.SCHL_principal_address = SCHL_principal_address;
school_rec.SCHL_principal_tele = SCHL_principal_tele;
school_rec.AGENT_id = AGENT_id;
school_rec.PROVINCE_id = PROVINCE_id;
school_rec.ZONE_id = ZONE_id;
school_rec.DIVISION_id = DIVISION_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(school_rec);
}
public TRN_Receipt_H Update(SchoolQPaper_entities entities, int RECEIPT_id, string RECEIPT_code, DateTime RECEIPT_date,
DateTime RECEIPT_tran_date, decimal RECEIPT_amount, string RECEIPT_remarks, string RECEIPT_font, int?SCHL_id,
int?AGENT_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_Receipt_H receipth_rec = entities.TRN_Receipt_H.Find(RECEIPT_id);
receipth_rec.RECEIPT_code = RECEIPT_code;
receipth_rec.RECEIPT_date = RECEIPT_date;
receipth_rec.RECEIPT_tran_date = RECEIPT_tran_date;
receipth_rec.RECEIPT_amount = RECEIPT_amount;
receipth_rec.RECEIPT_remarks = RECEIPT_remarks;
receipth_rec.RECEIPT_font = RECEIPT_font;
receipth_rec.SCHL_id = SCHL_id;
receipth_rec.AGENT_id = AGENT_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(receipth_rec);
}
public void Delete(SchoolQPaper_entities entities, int DIVISION_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
entities.MST_Division.Remove(entities.MST_Division.Find(DIVISION_id));
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
}
public void Delete(SchoolQPaper_entities entities, int TRAINST_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
entities.MST_TrainStation.Remove(entities.MST_TrainStation.Find(TRAINST_id));
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
}
public void Delete(SchoolQPaper_entities entities, int SCHL_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
entities.MST_School.Remove(entities.MST_School.Find(SCHL_id));
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
}
public void Delete(SchoolQPaper_entities entities, int PROVINCE_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
entities.MST_Province.Remove(entities.MST_Province.Find(PROVINCE_id));
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
}
public void Delete(SchoolQPaper_entities entities, int PPRODR01D_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
entities.TRN_PaperOrder01_D.Remove(entities.TRN_PaperOrder01_D.Find(PPRODR01D_id));
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
}
public void Delete(SchoolQPaper_entities entities, int RECEIPTD_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
entities.TRN_Receipt_D.Remove(entities.TRN_Receipt_D.Find(RECEIPTD_id));
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
}
public MST_TrainStation Update(SchoolQPaper_entities entities, int TRAINST_id, string TRAINST_name, string TRAINST_font)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_TrainStation trainstation_rec = entities.MST_TrainStation.Find(TRAINST_id);
trainstation_rec.TRAINST_name = TRAINST_name;
trainstation_rec.TRAINST_font = TRAINST_font;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(trainstation_rec);
}
public MST_Province Update(SchoolQPaper_entities entities, int PROVINCE_id, string PROVINCE_name, string PROVINCE_font)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Province province_rec = entities.MST_Province.Find(PROVINCE_id);
province_rec.PROVINCE_name = PROVINCE_name;
province_rec.PROVINCE_font = PROVINCE_font;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(province_rec);
}
public MST_Agent Update(SchoolQPaper_entities entities, int AGENT_id, string AGENT_name, string AGENT_font)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Agent agent_rec = entities.MST_Agent.Find(AGENT_id);
agent_rec.AGENT_name = AGENT_name;
agent_rec.AGENT_font = AGENT_font;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(agent_rec);
}
public MST_Province Insert(SchoolQPaper_entities entities, string PROVINCE_name, string PROVINCE_font)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Province province_rec = new MST_Province();
province_rec.PROVINCE_name = PROVINCE_name;
province_rec.PROVINCE_font = PROVINCE_font;
entities.MST_Province.Add(province_rec);
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(province_rec);
}
public MST_TrainStation Insert(SchoolQPaper_entities entities, string TRAINST_name, string TRAINST_font)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_TrainStation trainstation_rec = new MST_TrainStation();
trainstation_rec.TRAINST_name = TRAINST_name;
trainstation_rec.TRAINST_font = TRAINST_font;
entities.MST_TrainStation.Add(trainstation_rec);
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(trainstation_rec);
}
public MST_Zone Update(SchoolQPaper_entities entities, int ZONE_id, string ZONE_name, string ZONE_font, int PROVINCE_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Zone zone_rec = entities.MST_Zone.Find(ZONE_id);
zone_rec.ZONE_name = ZONE_name;
zone_rec.ZONE_font = ZONE_font;
zone_rec.PROVINCE_id = PROVINCE_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(zone_rec);
}
public MST_Agent Insert(SchoolQPaper_entities entities, string AGENT_name, string AGENT_font)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Agent agent_rec = new MST_Agent();
agent_rec.AGENT_name = AGENT_name;
agent_rec.AGENT_font = AGENT_font;
entities.MST_Agent.Add(agent_rec);
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(agent_rec);
}
public TRN_Receipt_PayType Update(SchoolQPaper_entities entities, int RECEIPTPAYTYP_id, decimal RECEIPTPAYTYP_amount,
int PAYTYP_id, int RECEIPT_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_Receipt_PayType receiptpaytype_rec = entities.TRN_Receipt_PayType.Find(RECEIPTPAYTYP_id);
receiptpaytype_rec.RECEIPTPAYTYP_amount = RECEIPTPAYTYP_amount;
receiptpaytype_rec.PAYTYP_id = PAYTYP_id;
receiptpaytype_rec.RECEIPT_id = RECEIPT_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(receiptpaytype_rec);
}
public TRN_Receipt_CHQ_Info Update(SchoolQPaper_entities entities, int RECEIPTCHQ_id, string RECEIPTCHQ_chq_no,
DateTime?RECEIPTCHQ_date, int RECEIPTPAYTYP_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_Receipt_CHQ_Info receiptchqinfo_rec = entities.TRN_Receipt_CHQ_Info.Find(RECEIPTCHQ_id);
receiptchqinfo_rec.RECEIPTCHQ_chq_no = RECEIPTCHQ_chq_no;
receiptchqinfo_rec.RECEIPTCHQ_date = RECEIPTCHQ_date;
receiptchqinfo_rec.RECEIPTPAYTYP_id = RECEIPTPAYTYP_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(receiptchqinfo_rec);
}
internal MST_Document Update(SchoolQPaper_entities entities, int DOCU_id, string DOCU_name, string DOCU_prefix,
int DOCU_last_no)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Document document_rec = entities.MST_Document.Find(DOCU_id);
document_rec.DOCU_name = DOCU_name;
document_rec.DOCU_prefix = DOCU_prefix;
document_rec.DOCU_last_no = DOCU_last_no;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(document_rec);
}
public MST_Division Update(SchoolQPaper_entities entities, int DIVISION_id, string DIVISION_name, string DIVISION_font,
int ZONE_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Division division_rec = entities.MST_Division.Find(DIVISION_id);
division_rec.DIVISION_name = DIVISION_name;
division_rec.DIVISION_font = DIVISION_font;
division_rec.ZONE_id = ZONE_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(division_rec);
}
public TRN_PaperOrder02_D Update(SchoolQPaper_entities entities, int PPRODR02D_id, int PPRODR02D_paper_qty, int GRADE_id,
int SUBJ_id, int PPRODR02_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_PaperOrder02_D paperorder02_d_rec = new TRN_PaperOrder02_D();
paperorder02_d_rec.PPRODR02D_paper_qty = PPRODR02D_paper_qty;
paperorder02_d_rec.GRADE_id = GRADE_id;
paperorder02_d_rec.SUBJ_id = SUBJ_id;
paperorder02_d_rec.PPRODR02_id = PPRODR02_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(paperorder02_d_rec);
}
public TRN_Receipt_D Update(SchoolQPaper_entities entities, int RECEIPTD_id, decimal RECEIPTD_amount, int RECEIPTD_doc_id,
int RECEIPT_id, int DOCU_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_Receipt_D receiptd_rec = entities.TRN_Receipt_D.Find(RECEIPTD_id);
receiptd_rec.RECEIPTD_amount = RECEIPTD_amount;
receiptd_rec.RECEIPTD_doc_id = RECEIPTD_doc_id;
receiptd_rec.RECEIPTD_id = RECEIPT_id;
receiptd_rec.DOCU_id = DOCU_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(receiptd_rec);
}
public TRN_PaperOrder01_H Insert(SchoolQPaper_entities entities, string PPRODR01_code, DateTime PPRODR01_datetime,
string PPRODR01_remarks, decimal PPRODR01_advanced_pay, string PPRODR01_cheque_no, string PPRODR01_mo_office,
int PPRODR01_additional_papers, string PPRODR01_font, decimal PPRODR01_gross_tot, decimal PPRODR01_discount_amnt,
decimal PPRODR01_net_tot, decimal PPRODR01_discount_percnt, string PPRODR01_telephone, string PPRODR01_train_received_by,
string PPRODR01_train_received_by_nic, int?TRAINST_id, int SCHL_id, int DELIMETH_id, int PAYTYP_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_PaperOrder01_H paperorder01_rec = new TRN_PaperOrder01_H();
paperorder01_rec.PPRODR01_code = PPRODR01_code;
paperorder01_rec.PPRODR01_datetime = PPRODR01_datetime;
paperorder01_rec.PPRODR01_remarks = PPRODR01_remarks;
paperorder01_rec.PPRODR01_advanced_pay = PPRODR01_advanced_pay;
paperorder01_rec.PPRODR01_cheque_no = PPRODR01_cheque_no;
paperorder01_rec.PPRODR01_mo_office = PPRODR01_mo_office;
paperorder01_rec.PPRODR01_additional_papers = PPRODR01_additional_papers;
paperorder01_rec.PPRODR01_font = PPRODR01_font;
paperorder01_rec.PPRODR01_gross_tot = PPRODR01_gross_tot;
paperorder01_rec.PPRODR01_discount_amnt = PPRODR01_discount_amnt;
paperorder01_rec.PPRODR01_net_tot = PPRODR01_net_tot;
paperorder01_rec.PPRODR01_discount_percnt = PPRODR01_discount_percnt;
paperorder01_rec.PPRODR01_telephone = PPRODR01_telephone;
paperorder01_rec.PPRODR01_train_received_by = PPRODR01_train_received_by;
paperorder01_rec.PPRODR01_train_received_by_nic = PPRODR01_train_received_by_nic;
paperorder01_rec.TRAINST_id = TRAINST_id;
paperorder01_rec.SCHL_id = SCHL_id;
paperorder01_rec.DELIMETH_id = DELIMETH_id;
paperorder01_rec.PAYTYP_id = PAYTYP_id;
entities.TRN_PaperOrder01_H.Add(paperorder01_rec);
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(paperorder01_rec);
}
public TRN_Receipt_MO_Info Insert(SchoolQPaper_entities entities, DateTime?RECEIPTMO_date, string RECEIPTMO_no,
string RECEIPTMO_office, int RECEIPTPAYTYP_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_Receipt_MO_Info receiptmoinfo_rec = new TRN_Receipt_MO_Info();
receiptmoinfo_rec.RECEIPTMO_date = RECEIPTMO_date;
receiptmoinfo_rec.RECEIPTMO_no = RECEIPTMO_no;
receiptmoinfo_rec.RECEIPTMO_office = RECEIPTMO_office;
receiptmoinfo_rec.RECEIPTPAYTYP_id = RECEIPTPAYTYP_id;
entities.TRN_Receipt_MO_Info.Add(receiptmoinfo_rec);
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(receiptmoinfo_rec);
}
public TRN_PaperOrder01_D Insert(SchoolQPaper_entities entities, int PPRODR01D_paper_qty, bool PPRODR01D_ignore_qty,
int GRADE_id, int SUBJ_id, int PPRODR01_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_PaperOrder01_D paperorder01_d_rec = new TRN_PaperOrder01_D();
paperorder01_d_rec.PPRODR01D_paper_qty = PPRODR01D_paper_qty;
paperorder01_d_rec.PPRODR01D_ignore_qty = PPRODR01D_ignore_qty;
paperorder01_d_rec.GRADE_id = GRADE_id;
paperorder01_d_rec.SUBJ_id = SUBJ_id;
paperorder01_d_rec.PPRODR01_id = PPRODR01_id;
entities.TRN_PaperOrder01_D.Add(paperorder01_d_rec);
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(paperorder01_d_rec);
}
public TRN_Receivable Update(SchoolQPaper_entities entities, int RECEIVABLES_id, int RECEIVABLES_doc_id, decimal RECEIVABLES_value,
decimal RECEIVABLES_balance, int?RECEIVABLES_ref_id, int DOCU_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_Receivable receivable_rec = entities.TRN_Receivable.Find(RECEIVABLES_id);
receivable_rec.RECEIVABLES_doc_id = RECEIVABLES_doc_id;
receivable_rec.RECEIVABLES_value = RECEIVABLES_value;
receivable_rec.RECEIVABLES_balance = RECEIVABLES_balance;
receivable_rec.RECEIVABLES_ref_id = RECEIVABLES_ref_id;
receivable_rec.DOCU_id = DOCU_id;
entities.SaveChanges();
if (dispose)
{
entities.Dispose();
}
return(receivable_rec);
}