public UndeliveredSalesOrdersWithDepositsModel GetDataIntoModel()
{
UndeliveredSalesOrdersWithDepositsModel JForm = new UndeliveredSalesOrdersWithDepositsModel();
JForm.UnpaidSalesInvoiceDetailsData = new List <UndeliveredSalesOrdersWithDepositsViewEntity>();
//UnpaidSalesInvoiceEntity model = new UnpaidSalesInvoiceEntity();
DateTime dt = new DateTime();
var c = DateFormat;
//JForm.UnpaidSalesInvoiceData = model;
foreach (var item in UnpaidSalesInvoicedetailsEntity)
{
if (item.ID != null)
{
UndeliveredSalesOrdersWithDepositsViewEntity jEntity = new UndeliveredSalesOrdersWithDepositsViewEntity();
jEntity.ID = item.ID;
jEntity.CustomerName = item.CustomerName;
jEntity.OrderNo = "OSO-" + item.OrderNo;
jEntity.OrderDate = item.OrderDate;
jEntity.OrderDateTime = DateTime.ParseExact(item.OrderDate, DateFormat, null);
jEntity.UndeliveredAmount = item.UndeliveredAmount;
jEntity.DepositAmount = item.DepositAmount;
if (item.ID != 0 && Convert.ToInt32(item.ID) > 0)
{
JForm.UnpaidSalesInvoiceDetailsData.Add(jEntity);
}
}
}
return(JForm);
}
public int SaveUndeliveredSalesOrderData(UndeliveredSalesOrdersWithDepositsModel model)
{
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
UndeliveredSalesOrderWithDeposit obj1;
if (model.UnpaidSalesInvoiceDetailsData != null)
{
foreach (UndeliveredSalesOrdersWithDepositsViewEntity JEntity in model.UnpaidSalesInvoiceDetailsData)
{
//save entity value
obj1 = new UndeliveredSalesOrderWithDeposit();
obj1.C_ID = JEntity.ID;
obj1.USalesOrder_No = JEntity.OrderNo;
obj1.USalesOrder_Date = JEntity.OrderDateTime;
obj1.USalesOrder_Amount = JEntity.UndeliveredAmount;
obj1.USalesOrderDeposit_Amount = JEntity.DepositAmount;
obj1.CreatedDate = DateTime.Now;
obj1.IsDeleted = false;
if (obj1 != null)
{
entities.UndeliveredSalesOrderWithDeposits.Add(obj1);
entities.SaveChanges();
}
//if (entities.UndeliveredSalesOrderWithDeposits.AsNoTracking().FirstOrDefault(x => x.ID == JEntity.ID) == null)
//{
// entities.UndeliveredSalesOrderWithDeposits.Add(obj1);
// entities.SaveChanges();
//}
//else
//{
// entities.Entry(obj1).State = EntityState.Modified;
// entities.SaveChanges();
//}
}
}
else
{
}
}
return(1);
}
catch (Exception e)
{
// return 0;
throw e;
}
}
public string ValidateJournal()
{
string msg = string.Empty;
UndeliveredSalesOrdersWithDepositsModel JForm = GetDataIntoModel();
//var tempInvoiceNumber = undeliveredSalesOrderRepository.IsChequeNoPresent();
//string result = JForm.UnpaidSalesInvoiceDetailsData.Where(x => x.OrderNo == tempInvoiceNumber).Select(x => x.OrderNo).FirstOrDefault();
//if (result != null)
//{
// msg = "Entry against Cheque No is already done";
//}
//return msg;
List <string> ListInvoiceNumber = undeliveredSalesOrderRepository.IsChequeNoPresent();
List <string> InsideList = JForm.UnpaidSalesInvoiceDetailsData.Select(x => x.OrderNo).ToList();
List <string> PINumberList = InsideList.Distinct().ToList();
foreach (var item in JForm.UnpaidSalesInvoiceDetailsData)
{
if (InsideList.Count != PINumberList.Count)
{
msg = "Two Invoice Number Should Not Be Same";
//this.CASErrors =msg;
break;
}
if (ListInvoiceNumber == null)
{
msg = "No Entry is done till Now";
//this.CASErrors=msg;
break;
}
if (ListInvoiceNumber.Contains(item.OrderNo))
{
msg = "Entry against Cheque No is already done ";
// this.CASErrors = msg;
break;
}
}
return(msg);
}
public void SaveUnpaidSalesInvoice(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 && msg != "No Entry is done till Now")
{
CASErrors = msg;
Mouse.OverrideCursor = null;
return;
}
CASErrors = string.Empty;
UndeliveredSalesOrdersWithDepositsModel model = GetDataIntoModel();
undeliveredSalesOrderRepository.SaveUndeliveredSalesOrderData(model);
Mouse.OverrideCursor = null;
}
}
public int SaveUndeliveredSalesOrderData(UndeliveredSalesOrdersWithDepositsModel model)
{
IUndeliveredSalesOrdersWithDepositsDAL obj = new UndeliveredSalesOrdersWithDepositsDAL();
return(obj.SaveUndeliveredSalesOrderData(model));
}
