private void btnSelect_Click(object sender, EventArgs e)
{
Form1 mdiParent = (Form1)this._journalForm.MdiParent;
this._journalForm.Close();
this._journalForm = new JournalForm();
this._journalForm._journal = this._Journal;
this._journalForm.MdiParent = mdiParent;
this._journalForm.old = true;
this._journalForm.dateString = this.dateString;
if (this.dateType == TagType.Day)
{
this._journalForm.dtDate.Text = this.dateString;
}
else
{
this._journalForm.dtDate.Enabled = false;
}
this._journalForm.btnAdd.Enabled = false;
this._journalForm.resetUI(mdiParent.UserName);
this._journalForm.Anchor = AnchorStyles.Top | AnchorStyles.Right;
this._journalForm.Dock = DockStyle.Fill;
this._journalForm.Show();
base.Close();
base.Dispose();
}
public JournalForm GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
JournalForm JForm = new JournalForm();
JForm.JournalaDataDetails= new List<JournalFormEntity>();
JournalFormEntity model = new JournalFormEntity();
model.JournalNo = this.JournalNo;
model.JournalDate = DateTime.ParseExact(this.JournalDateStr, oData.DateFormat, null);
JForm.JournalData = model;
foreach (var item in JournalDetailsEntity)
{
if (item.ID != null)
{
JournalFormEntity jEntity = new JournalFormEntity();
jEntity.ID = item.ID;
jEntity.JournalDateStr = item.JournalDateStr;
jEntity.Credit = item.Credit;
jEntity.Debit = item.Debit;
if (item.ID != 0 && Convert.ToInt32(item.ID) > 0)
{
JForm.JournalaDataDetails.Add(jEntity);
}
}
}
return JForm;
}
public void GetJournalDetails(string JNo)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
string obj = JNo.ToString();
JournalForm JObj = journalRepository.GetJournalDetails(obj);
this.JournalNo = JObj.JournalData.JournalNo;
DateTime Dateinstr = (DateTime)JObj.JournalData.JournalDate;
this.JournalDateStr = Dateinstr.ToString(oData.DateFormat);
this.JournalDetailsEntity = new ObservableCollection<JGridViewModel>();
this.sumCredit =Convert.ToString(JObj.JournalaDataDetails.Sum(x => x.Credit));
this.sumDebit = Convert.ToString(JObj.JournalaDataDetails.Sum(x => x.Debit));
foreach (var item in JObj.JournalaDataDetails)
{
JGridViewModel pqEntity = new JGridViewModel(JournalList);
pqEntity.ID = item.ID;
pqEntity.JournalDateStr = item.JournalDateStr;
pqEntity.Credit = item.Credit;
pqEntity.Debit = item.Debit;
JournalDetailsEntity.Add(pqEntity);
}
}
public JournalFormPresenter(JournalForm form, TicketBLL ticket)
{
this.form = form;
validator = new FormValidator();
userTicket = ticket;
getServices();
reloadRequestsGrid();
}
private void btnJournal_Click(object sender, EventArgs e)
{
this.deleteSubs();
JournalForm journalForm = new JournalForm();
journalForm.MdiParent = (Form1)this.MdiParent;
journalForm.Anchor = AnchorStyles.Top | AnchorStyles.Right;
journalForm.Dock = DockStyle.Fill;
journalForm.Show();
}
public JournalForm GetJournalDetails(string JNo)
{
JournalForm JSform = new JournalForm();
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
var pq = (from pqs in entities.Journals
where pqs.J_No == JNo
select new JournalFormEntity
{
JournalNo = pqs.J_No,
JournalDate = pqs.J_Date,
}).FirstOrDefault();
if (pq != null)
{
JSform.JournalData = pq;
}
var pqd = (from pqs in entities.JournalDetails
where pqs.JO_No == JNo
select new JournalFormEntity
{
ID = pqs.Acc_ID,
JournalDate = pqs.JO_Date,
JournalNo = pqs.JO_No,
Credit = pqs.JO_Credit_,
Debit = pqs.JO_Debit_,
}).ToList <JournalFormEntity>();
if (pqd != null)
{
JSform.JournalaDataDetails = pqd;
}
return(JSform);
}
}
catch (Exception ex) { throw ex; }
}
public void SaveJournalData(object param)
{
MessageBoxResult result = System.Windows.MessageBox.Show("Do you want to save changes?", "Save Confirmation", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;
string msg = ValidateJournal();
if (msg != string.Empty)
{
CASErrors = msg;
Mouse.OverrideCursor = null;
return;
}
CASErrors = string.Empty;
JournalForm JForm = GetDataIntoModel();
int i = 0;
if (IsNew == true)
{
i = journalRepository.SaveJournalData(JForm);
}
//else
//{
// i = casRepository.UpdateCountAndAdjustStock(JForm);
//}
if (i > 0)
{
IsNew = false;
}
Mouse.OverrideCursor = null;
_IsSave = false;
}
_IsSave = true;
}
public int SaveJournalData(JournalForm JForm)
{
IJournalFormBL JournalObj = new JournalFormBL();
return(JournalObj.SaveJournalData(JForm));
}
public int SaveJournalData(JournalForm JForm)
{
int autoId = 0;
Journal obj = new Journal();
obj.J_No = JForm.JournalData.JournalNo;
obj.J_Date = JForm.JournalData.JournalDate;
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
if (entities.Journals.AsNoTracking().FirstOrDefault(x => x.ID == JForm.JournalData.ID) == null)
{
//obj.CreatedBy = invoiceData.SIModel.CreatedBy;
obj.J_CreatedDate = DateTime.Now;
entities.Journals.Add(obj);
entities.SaveChanges();
autoId = obj.ID;
}
else
{
// obj.ModifiedBy = invoiceData.SIModel.ModifiedBy;
obj.J_ModifiedDate = DateTime.Now;
entities.Entry(obj).State = EntityState.Modified;
autoId = entities.SaveChanges();
}
JForm.JournalData.ID = autoId;
if (autoId > 0)
{
JournalDetail obj1;
if (JForm.JournalaDataDetails != null)
{
foreach (JournalFormEntity JEntity in JForm.JournalaDataDetails)
{
//save entity value
obj1 = new JournalDetail();
obj1.Acc_ID = JEntity.ID;
obj1.JO_ID_ = autoId;
obj1.JO_No = JForm.JournalData.JournalNo;
obj1.JO_Date = JForm.JournalData.JournalDate;
obj1.JO_Debit_ = JEntity.Debit;
obj1.JO_Credit_ = JEntity.Credit;
if (entities.JournalDetails.AsNoTracking().FirstOrDefault(x => x.ID == JEntity.ID) == null)
{
entities.JournalDetails.Add(obj1);
entities.SaveChanges();
}
else
{
entities.Entry(obj1).State = EntityState.Modified;
entities.SaveChanges();
}
}
}
}
else
{
}
}
return(autoId);
}
catch (Exception ex)
{
return(0);
throw ex;
}
//return 1;
}
public void openJournals()
{
JournalForm form = new JournalForm(currentUser);
form.Show();
}
