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 PPRODR01_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
System.Data.Entity.DbContextTransaction trans = null;
if (dispose)
{
trans = entities.Database.BeginTransaction();
}
entities.TRN_PaperOrder01_D.Where(x => x.PPRODR01_id == PPRODR01_id).ToList().ForEach(r =>
{
new TRN_PaperOrder01_D_Class().Delete(entities, r.PPRODR01D_id);
});
new TRN_PaperOrder01_H_Class().Delete(entities, PPRODR01_id);
int RECEIVABLES_id = entities.TRN_Receivable.Where(x => x.RECEIVABLES_doc_id == PPRODR01_id && x.DOCU_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_O_L_Invoice).FirstOrDefault().RECEIVABLES_id;
entities.TRN_Receivable.Where(x => x.RECEIVABLES_ref_id != null && x.RECEIVABLES_ref_id == RECEIVABLES_id && x.DOCU_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Receipt).ToList().ForEach(r =>
{
new Receipt.Receipt_Class().Delete(entities, r.RECEIVABLES_doc_id);
});
new TRN_Receivable_Class().Delete(entities, RECEIVABLES_id);
if (dispose)
{
trans.Commit();
trans.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 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 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 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 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 string GetDocumentCode(SchoolQPaper_entities entities, int DOCU_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
MST_Document document_rec = entities.MST_Document.Find(DOCU_id);
string Code = document_rec.DOCU_prefix + new SchoolQPaper.MST_Document_Class().Update(entities, DOCU_id, document_rec.DOCU_name, document_rec.DOCU_prefix, document_rec.DOCU_last_no + 1).DOCU_last_no.ToString().PadLeft(7, '0');
if (dispose)
{
entities.Dispose();
}
return(Code);
}
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_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_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_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_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 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_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 void Delete(SchoolQPaper_entities entities, int RECEIPT_id)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
System.Data.Entity.DbContextTransaction trans = null;
if (dispose)
{
trans = entities.Database.BeginTransaction();
}
entities.TRN_Receipt_PayType.ToList().ForEach(r =>
{
if (r.TRN_Receipt_MO_Info.Count != 0)
{
new TRN_Receipt_MO_Info_Class().Delete(entities, r.TRN_Receipt_MO_Info.FirstOrDefault().RECEIPTMO_id);
}
if (r.TRN_Receipt_CHQ_Info.Count != 0)
{
new TRN_Receipt_CHQ_Info_Class().Delete(entities, r.TRN_Receipt_CHQ_Info.FirstOrDefault().RECEIPTCHQ_id);
}
new TRN_Receipt_PayType_Class().Delete(entities, r.RECEIPTPAYTYP_id);
});
entities.TRN_Receipt_D.ToList().ForEach(r =>
{
new TRN_Receipt_D_Class().Delete(entities, r.RECEIPTD_id);
});
new TRN_Receipt_H_Class().Delete(entities, RECEIPT_id);
new TRN_Receivable_Class().Delete(entities, entities.TRN_Receivable.Where(x => x.RECEIVABLES_doc_id == RECEIPT_id && x.DOCU_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Receipt).FirstOrDefault().RECEIVABLES_id);
if (dispose)
{
trans.Commit();
trans.Dispose();
entities.Dispose();
}
}
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);
}
public TRN_Receipt_H Save(SchoolQPaper_entities entities, 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,
Data.Grid_DS.DS_Receipt DS_Receipt_Obj)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_Receipt_H receipth_rec = null;
System.Data.Entity.DbContextTransaction trans = null;
if (dispose)
{
trans = entities.Database.BeginTransaction();
}
try
{
RECEIPT_code = new Document.Document_Class().GetDocumentCode(entities, Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Receipt);
receipth_rec = new TRN_Receipt_H_Class().Insert(entities,
RECEIPT_code,
RECEIPT_date,
RECEIPT_tran_date,
RECEIPT_amount,
RECEIPT_remarks,
RECEIPT_font,
SCHL_id,
AGENT_id);
DS_Receipt_Obj.OutstandingInvoices.ToList().ForEach(r =>
{
if (r.RECEIPTD_amount != 0)
{
new TRN_Receipt_D_Class().Insert(entities,
r.RECEIPTD_amount,
r.RECEIPTD_doc_id,
receipth_rec.RECEIPT_id,
r.DOCU_id);
var outstanding_receivable_rec = entities.TRN_Receivable.Where(x => x.RECEIVABLES_doc_id == r.RECEIPTD_doc_id && x.DOCU_id == r.DOCU_id).FirstOrDefault();
if (outstanding_receivable_rec.RECEIVABLES_balance - r.RECEIPTD_amount < 0)
{
throw new AppErrorException("Invalid Receipt Amount", "The receipt amount exceeds the outstanding balance on " + r.RECEIPTD_doc_text + ".");
}
new TRN_Receivable_Class().Update(entities,
outstanding_receivable_rec.RECEIVABLES_id,
outstanding_receivable_rec.RECEIVABLES_doc_id,
outstanding_receivable_rec.RECEIVABLES_value,
outstanding_receivable_rec.RECEIVABLES_balance - r.RECEIPTD_amount,
outstanding_receivable_rec.RECEIVABLES_ref_id,
outstanding_receivable_rec.DOCU_id);
new TRN_Receivable_Class().Insert(entities,
receipth_rec.RECEIPT_id,
r.RECEIPTD_amount,
0,
outstanding_receivable_rec.RECEIVABLES_id,
Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Receipt);
}
});
DS_Receipt_Obj.PayTypes.ToList().ForEach(r =>
{
var receiptpaytype_rec = new TRN_Receipt_PayType_Class().Insert(entities,
r.RECEIPTPAYTYP_amount,
r.PAYTYP_id,
receipth_rec.RECEIPT_id);
if (r.PAYTYP_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_PayType.Records.MO)
{
var moneyorderinfo_rec = DS_Receipt_Obj.MoneyOrderInfo.Where(x => x.PayTypes_Id == r.Id).FirstOrDefault();
new TRN_Receipt_MO_Info_Class().Insert(entities,
moneyorderinfo_rec.RECEIPTMO_date,
moneyorderinfo_rec.RECEIPTMO_no,
moneyorderinfo_rec.RECEIPTMO_office,
receiptpaytype_rec.RECEIPTPAYTYP_id);
}
else if (r.PAYTYP_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_PayType.Records.Cheque)
{
var chequeinfo_rec = DS_Receipt_Obj.ChequeInfo.Where(x => x.PayTypes_Id == r.Id).FirstOrDefault();
new TRN_Receipt_CHQ_Info_Class().Insert(entities,
chequeinfo_rec.RECEIPTCHQ_chq_no,
chequeinfo_rec.RECEIPTCHQ_date,
receiptpaytype_rec.RECEIPTPAYTYP_id);
}
});
if (dispose)
{
trans.Commit();
}
}
catch (Exception ex)
{
if (dispose)
{
trans.Rollback();
}
throw ex;
}
if (dispose)
{
trans.Dispose();
entities.Dispose();
}
return(receipth_rec);
}
public TRN_PaperOrder01_H Save(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, Tuple <int?, string> MST_TrainStation_rec, int SCHL_id, int DELIMETH_id,
int PAYTYP_id,
List <PaperOrderD_Rec> PaperOrderD_Recs)
{
bool dispose = entities == null;
entities = entities ?? new SchoolQPaper_entities();
TRN_PaperOrder01_H paperorder01_rec = null;
System.Data.Entity.DbContextTransaction trans = null;
if (dispose)
{
trans = entities.Database.BeginTransaction();
}
try
{
if (MST_TrainStation_rec.Item1 != null && MST_TrainStation_rec.Item1 == 0)
{
var trainstation_rec = new MST_TrainStation_Class().Insert(entities, MST_TrainStation_rec.Item2, PPRODR01_font);
MST_TrainStation_rec = new Tuple <int?, string>(trainstation_rec.TRAINST_id, trainstation_rec.TRAINST_name);
}
PPRODR01_code = new Document.Document_Class().GetDocumentCode(entities, Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_O_L_Invoice);
paperorder01_rec = new TRN_PaperOrder01_H_Class().Insert(entities,
PPRODR01_code,
PPRODR01_datetime,
PPRODR01_remarks,
PPRODR01_advanced_pay,
PPRODR01_cheque_no,
PPRODR01_mo_office,
PPRODR01_additional_papers,
PPRODR01_font,
PPRODR01_gross_tot,
PPRODR01_discount_amnt,
PPRODR01_net_tot,
PPRODR01_discount_percnt,
PPRODR01_telephone,
PPRODR01_train_received_by,
PPRODR01_train_received_by_nic,
MST_TrainStation_rec.Item1,
SCHL_id,
DELIMETH_id,
PAYTYP_id);
PaperOrderD_Recs.ForEach(r =>
{
new TRN_PaperOrder01_D_Class().Insert(entities, r.PPRODR01D_paper_qty, r.PPRODR01D_ignore_qty, r.GRADE_id, r.SUBJ_id, paperorder01_rec.PPRODR01_id);
});
new TRN_Receivable_Class().Insert(entities,
paperorder01_rec.PPRODR01_id,
PPRODR01_net_tot,
PPRODR01_net_tot,
null,
Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_O_L_Invoice);
if (PPRODR01_advanced_pay != 0)
{
DS_Receipt DS_Receipt_Obj = new DS_Receipt();
DS_Receipt_Obj.OutstandingInvoices.AddOutstandingInvoicesRow(paperorder01_rec.PPRODR01_id,
Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_O_L_Invoice,
PPRODR01_code,
PPRODR01_advanced_pay,
PPRODR01_net_tot,
SCHL_id,
"",
"",
Settings.Default.CurrentFont);
int PayTypes_Id = DS_Receipt_Obj.PayTypes.AddPayTypesRow(PAYTYP_id,
"",
PPRODR01_advanced_pay,
"",
"").Id;
if (PAYTYP_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_PayType.Records.Cheque)
{
DS_Receipt_Obj.ChequeInfo.AddChequeInfoRow(PayTypes_Id,
PPRODR01_cheque_no,
DateTime.Now);
}
else if (PAYTYP_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_PayType.Records.MO)
{
DS_Receipt_Obj.MoneyOrderInfo.AddMoneyOrderInfoRow(PayTypes_Id,
DateTime.Now,
PPRODR01_cheque_no,
PPRODR01_mo_office);
}
new Receipt.Receipt_Class().Save(entities,
"",
PPRODR01_datetime,
PPRODR01_datetime,
PPRODR01_advanced_pay,
"",
Settings.Default.CurrentFont,
SCHL_id,
null,
DS_Receipt_Obj);
}
if (dispose)
{
trans.Commit();
}
}
catch (Exception ex)
{
if (dispose)
{
trans.Rollback();
}
throw ex;
}
if (dispose)
{
trans.Dispose();
entities.Dispose();
}
return(paperorder01_rec);
}
