//public bool UpdateInvoiceDataItemFromPurchaseRegsiter(GST_TRN_INVOICE invoice)
//{
// var prData = unitOfWork.PurchaseRegisterDataRepositry.Find(f => f.SupplierInvoiceNo == invoice.InvoiceNo);
// if (prData != null)
// {
// foreach (GST_MST_PURCHASE_DATA data in prData.GST_MST_PURCHASE_DATA)
// {
// unitOfWork.PurchaseDataRepositry.Delete(data);
// }
// unitOfWork.Save();
// }
// UpdatePurchaseData(invoice);
// return true;
//}
private GST_MST_PURCHASE_REGISTER Purchase_Register_Data(GST_TRN_INVOICE invoice)
{
GST_MST_PURCHASE_REGISTER PR = new GST_MST_PURCHASE_REGISTER();
if (invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.Import)
{
PR.SellerName = SellerName; //invoice.AspNetUser.OrganizationName;
PR.SellerAddress = SellerAddress; //invoice.AspNetUser.Address;
PR.SellerGSTN = SellerGSTN; //invoice.AspNetUser.GSTNNo;
PR.ReceiverName = ReceiverName; //invoice.AspNetUser1.OrganizationName;
PR.ReceiverAddress = ReceiverAddress; //invoice.AspNetUser1.Address;
PR.ConsigneeName = ConsigneeName; //invoice.AspNetUser2.OrganizationName;
PR.ConsigneeAddress = ConsigneeAddress; //invoice.AspNetUser2.Address;
PR.StateCode = StateCode;
}
else
{
PR.SellerName = invoice.AspNetUser.OrganizationName;
PR.SellerAddress = invoice.AspNetUser.Address;
PR.SellerGSTN = invoice.AspNetUser.GSTNNo;
PR.ReceiverName = invoice.AspNetUser1.OrganizationName;
PR.ReceiverAddress = invoice.AspNetUser1.Address;
PR.ConsigneeName = invoice.AspNetUser2.OrganizationName;
PR.ConsigneeAddress = invoice.AspNetUser2.Address;
PR.StateCode = Convert.ToString(invoice.AspNetUser.StateCode);
}
PR.UserID = LoggedinUserID;
PR.StockInwardDate = DateTime.Now;
PR.StockOrderDate = invoice.InvoiceDate;
PR.OrderPo = null; //TODO
PR.OrderPoDate = null; //TODO
PR.SupplierInvoiceNo = invoice.InvoiceNo;
PR.SupplierInvoiceDate = invoice.InvoiceDate;
PR.SupplierInvoiceMonth = invoice.InvoiceMonth;
PR.Freight = invoice.Freight;
PR.Insurance = invoice.Insurance;
PR.PackingAndForwadingCharges = invoice.PackingAndForwadingCharges;
PR.ElectronicReferenceNo = invoice.ElectronicReferenceNo;
PR.ElectronicReferenceNoDate = invoice.ElectronicReferenceNoDate;
//PR.StateID = getinvocdtls.
PR.PurchaseStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh);
PR.Status = true;
PR.CreatedBy = invoice.CreatedBy;
PR.CreatedDate = DateTime.Now;
List <GST_MST_PURCHASE_DATA> data = new List <GST_MST_PURCHASE_DATA>();
foreach (GST_TRN_INVOICE_DATA invData in invoice.GST_TRN_INVOICE_DATA)
{
data.Add(PurchaseData(invData));
}
PR.GST_MST_PURCHASE_DATA = data;
return(PR);
}
public bool SavePurchaseRegister(GST_MST_PURCHASE_REGISTER purchaseRegister)
{
try
{
unitOfWork.PurchaseRegisterDataRepositry.Create(purchaseRegister);
unitOfWork.Save();
return(true);
}
catch (Exception ex)
{ return(false); }
}
private void BindPurchaseData(GST_MST_PURCHASE_REGISTER registerData)
{
List <GST_MST_PURCHASE_DATA> listObject = new List <GST_MST_PURCHASE_DATA>();
listObject = registerData.GST_MST_PURCHASE_DATA.ToList();
foreach (GST_MST_PURCHASE_DATA item in CreateBlankItem())
{
listObject.Add(item);
}
lv_purchasedata.DataSource = listObject;
lv_purchasedata.DataBind();
}
private void SaveQtyUpdate()
{
try
{
GST_MST_PURCHASE_REGISTER register = new GST_MST_PURCHASE_REGISTER();
// register.Item_ID = unitOfwork.ItemRepository.Find(f => f.ItemCode == txtItem.Text.Trim()).Item_ID;
// register.Qty = Convert.ToDecimal(txtQty.Text.Trim());
// register.PerUnitRate = Convert.ToDecimal(txtPerUnitRate.Text.Trim());
DateTime InwardDate = DateTime.ParseExact(txtStockInwardDate.Text.Trim(), "dd/MM/yyyy", null);
register.StockInwardDate = InwardDate;
DateTime OrderdDate = DateTime.ParseExact(txtStockOrderDate.Text.Trim(), "dd/MM/yyyy", null);
register.StockInwardDate = OrderdDate;
DateTime orderPoDate = DateTime.ParseExact(txtOrderPoDate.Text.Trim(), "dd/MM/yyyy", null);
register.OrderPoDate = orderPoDate;
//register.StockInwardDate = Convert.ToDateTime(txtStockInwardDate.Text.Trim());
//register.StockOrderDate = Convert.ToDateTime(txtStockOrderDate.Text.Trim());
//register.OrderPoDate = Convert.ToDateTime(txtOrderPoDate.Text.Trim());
register.OrderPo = txtOrderPo.Text.Trim();
register.SupplierInvoiceNo = txtSupplierInvoiceNo.Text.Trim();
register.UserID = SellerUserID;
register.Status = true;
register.CreatedBy = Common.LoggedInUserID();
register.CreatedDate = DateTime.Now;
unitOfwork.PurchaseRegisterDataRepositry.Create(register);
unitOfwork.Save();
ClearControl();
}
catch (Exception ex)
{
cls_ErrorLog ob = new cls_ErrorLog();
cls_ErrorLog.LogError(ex, Common.LoggedInUserID());
}
}
protected void btnSaveRegister_Click(object sender, EventArgs e)
{
if (ddlState.SelectedValue == "0")
{
uc_sucess.ErrorMessage = "Please Select State Name.";
return;
}
try
{
var ITEM = unitOfwork.PurchaseRegisterDataRepositry.Find(F => F.SupplierInvoiceNo == txtSupplierInvoiceNumber.Text.Trim());
GST_MST_PURCHASE_REGISTER register = new GST_MST_PURCHASE_REGISTER();
if (ITEM == null)
{
int count = 0;
register.SellerGSTN = txtSellerGSTIN.Text.Trim();
register.SellerName = txtSellerName.Text.Trim();
register.SellerAddress = txtSellerAddress.Text.Trim();
register.ReceiverName = txtRecieverName.Text.Trim();
register.ReceiverAddress = txtRecieverName.Text.Trim();
register.ConsigneeName = txtConsigneeName.Text.Trim();
register.ConsigneeAddress = txtConsigneeAddress.Text.Trim();
DateTime SOrderDate = DateTime.ParseExact(txtStockOrderDate.Text, "dd/MM/yyyy", null);
register.StockOrderDate = SOrderDate;
DateTime SInwardDate = DateTime.ParseExact(txtStockInwardDate.Text, "dd/MM/yyyy", null);
register.StockInwardDate = SInwardDate;
register.OrderPo = txtOrderPo.Text.Trim();
DateTime SOrderpoDate = DateTime.ParseExact(txtOrderPoDate.Text, "dd/MM/yyyy", null);
register.OrderPoDate = SOrderpoDate;
register.SupplierInvoiceNo = txtSupplierInvoiceNumber.Text.Trim();
DateTime SInvoiceDate = DateTime.ParseExact(txtSupplierInvoiceDate.Text, "dd/MM/yyyy", null);
register.SupplierInvoiceDate = SInvoiceDate;
register.SupplierInvoiceMonth = Convert.ToByte(ddlmonth.SelectedIndex.ToString());
register.StateCode = ddlState.SelectedItem.Value;
register.Insurance = Convert.ToDecimal(txtInsurance.Text.Trim());
register.Freight = Convert.ToDecimal(txtFreight.Text.Trim());
register.Status = true;
register.PackingAndForwadingCharges = Convert.ToDecimal(txtcharges.Text.Trim());
if (register.StockInwardDate >= register.StockOrderDate)
{
uc_sucess2.ErrorMessage = "Stock inward date should be less then stock order date.";
return;
}
register.OrderPo = txtOrderPo.Text.Trim();
// register.SupplierInvoiceNo = txtSupplierInvoiceNo.Text.Trim();
register.UserID = Common.LoggedInUserID();
// register.Status = true;
register.CreatedBy = Common.LoggedInUserID();
register.CreatedDate = DateTime.Now;
unitOfwork.PurchaseRegisterDataRepositry.Create(register);
unitOfwork.Save();
count = count + 1;
if (count > 0)
{
this.Master.SuccessMessage = "Data submitted successfully !";
//uc_sucess.Visible = true;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "viewInvoiceModelSucessMessage", "$('#viewInvoiceModelSucessMessage').modal();", true);
uc_Purchase_Data.BindInvoiceNum();
BindPurchageItems();
}
else
{
this.Master.WarningMessage = "Enter valid data !.";
//uc_sucess.Visible = true;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "viewInvoiceModelWarningMessage", "$('#viewInvoiceModelWarningMessage').modal();", true);
}
//uc_sucess.SuccessMessage = "Data Submited Successfully.";
ClearControl();
}
else
{
uc_sucess.ErrorMessage = "Supplier Invoice No. Already Exist!";
}
}
catch (Exception ex)
{
cls_ErrorLog ob = new cls_ErrorLog();
cls_ErrorLog.LogError(ex, Common.LoggedInUserID());
this.Master.ErrorMessage = ex.Message;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "viewInvoiceModelErrorMessage", "$('#viewInvoiceModelErrorMessage').modal();", true);
}
}