public void PostCreditInvoiceCompletedSignalToNav(Config config, Guid invoiceId, string invoiceNumber)
{
var url = config.NavApiBaseUrl + "/" + config.NavPath + $"/companies({config.NavCompanyId})/salesCreditMemos";
var newUrl = url + $"({invoiceId.ToString()})/Microsoft.NAV.Cancel";
var client = NAV.NAVClient(newUrl, config);
var request = new RestRequest(Method.POST);
request.AddHeader("Content-Type", "application/json");
IRestResponse response = client.Execute(request);
if (response.Content == "")
{
//posted successfully
CreditNote _invoice = _context.CreditNote.FirstOrDefault(x => x.Credit_Note_Number == invoiceNumber);
if (_invoice != null)
{
_invoice.IsNavPosted = true;
_context.Entry(_invoice).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
}
}
else
{
string errorMessage = "Error Credit Note post, Credit Note= " + invoiceId + " Message= " + response.Content + " " + DateTime.Now.ToString() + Environment.NewLine;
WriteToFile(Path.GetFullPath("logs/"), "NAVSyncLog.log", errorMessage);
//_logger.LogError("Error Credit Note post, Credit Note= " + invoiceId + " Message= " + response.Content + " " + DateTime.Now.ToString());
}
}
protected void btnget_Click(object sender, EventArgs e)
{
string from = txtfromDate.Text.Split('/')[2] + "/" + txtfromDate.Text.Split('/')[1] + "/" + txtfromDate.Text.Split('/')[0];
string To = txttoDate.Text.Split('/')[2] + "/" + txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0];
fdate = Convert.ToDateTime(from);
tdate = Convert.ToDateTime(To);
if (fdate > tdate)
{
MessageBox("From Date is Greater than ToDate");
txtfromDate.Focus();
}
else
{
DataTable dt = new DataTable();
dt = CreditNote.GetTotalCN_Bydt(Convert.ToInt32(strFY), fdate, tdate).Tables[0];
if (dt.Rows.Count > 0)
{
Session["CNlist"] = dt;
show(dt);
}
else
{
MessageBox("No Records Found");
}
}
//show();
}
protected void DDLCustomer_SelectedIndexChanged(object sender, EventArgs e)
{
frdate = txtFromDate.Text.Split('/')[2] + "/" + txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0];
todate = txttoDate.Text.Split('/')[2] + "/" + txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0];
tdt = Convert.ToDateTime(todate);
fdt = Convert.ToDateTime(frdate);
// Rptrpending.DataSource = CreditNote.GetCNNo_byCust(Convert.ToInt32(DDLCustomer.SelectedValue));
RptrCN.DataSource = CreditNote.GetCNNo_byCust(Convert.ToInt32(strFY), (DDLCustomer.SelectedValue), "All", fdt, tdt);
RptrCN.DataBind();
//RptrCN2.DataSource = CreditNote.GetCNNo_byCust((DDLCustomer.SelectedValue), "Manual");
//RptrCN2.DataBind();
RptrCN.Visible = true;
// RptrCN2.Visible = true;
PnlPrint.Visible = false;
Pnl2.Visible = true;
//DataTable dt = new DataTable();
//dt = DCReturnBook.GetCustAddress((DDLCustomer.SelectedValue), "CNCustlist").Tables[0];
//if (dt.Rows.Count > 0)
//{
// lblCustName.Text = dt.Rows[0]["CustName"].ToString();
// lblCustAddress.Text = dt.Rows[0]["Address"].ToString();
//}
if (DDLCustomer.SelectedIndex == 0)
{
Pnl2.Visible = false;
PnlPrint.Visible = false;
}
}
/// <summary>
/// Used only for cancelling document
/// </summary>
/// <param name="documentEntity"></param>
private void Save(CreditNote documentEntity)
{
tblDocument docToSave = SaveDocument(documentEntity);
CreditNote r = documentEntity as CreditNote;
docToSave.InvoiceOrderId = r.InvoiceId;
foreach (CreditNoteLineItem rli in r.LineItems)
{
tblLineItems ll = null;
if (docToSave.tblLineItems.Any(n => n.id == rli.Id))
ll = docToSave.tblLineItems.First(n => n.id == rli.Id);
else
{
ll = new tblLineItems();
ll.id = rli.Id;
ll.DocumentID = documentEntity.Id;
docToSave.tblLineItems.Add(ll);
}
ll.ProductID = rli.Product.Id;
ll.Value = rli.Value;
ll.Quantity = rli.Qty;
ll.Description = rli.Description;
ll.LineItemSequenceNo = rli.LineItemSequenceNo;
}
_ctx.SaveChanges();
}
public void UpdateCreditNote(CreditNoteForm CreditNote)
{
try
{
using (SDNSalesDBEntities entities = new SDNSalesDBEntities())
{
CreditNote obj = entities.CreditNotes.Where(e => e.CN_No == CreditNote.CreditNote.CreditNo
).SingleOrDefault();
if (obj != null)
{
if (!string.IsNullOrEmpty(CreditNote.CreditNote.CustomerDebitNoteAmount))
{
CreditNote.CreditNote.CDNAmount = Convert.ToDecimal(CreditNote.CreditNote.CustomerDebitNoteAmount);
}
obj.Cus_DN_No = CreditNote.CreditNote.CustomerDebitNoteNo;
obj.Cus_DN_Date = CreditNote.CreditNote.CustomerDebitNoteDate;
obj.Cus_DN_Amount = CreditNote.CreditNote.CDNAmount;
obj.ModifiedDate = DateTime.Now;
entities.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Loads the credit note information on the page
/// </summary>
/// <param name="creditNoteID"></param>
public void loadCreditNote(int creditNoteID)
{
creditNote = CreditNoteViewModel.getCreditNote(creditNoteID);
if (creditNote != null)
{
// Customer details
textBox_Customer.Text = creditNote.customer.CustomerName;
textBox_Contact_Details.Text = creditNote.customer.PhoneNumber.ToString();
textBox_Email_Address.Text = creditNote.customer.Email;
textBox_Address.Text = creditNote.customer.Address + ", " + creditNote.customer.City + ", " +
creditNote.customer.Country;
// Credit Note details
txtBox_creditNoteNumber.Text = creditNote.idCreditNote.ToString();
txtBox_creditNoteNumber.IsReadOnly = true;
txtBox_createdDate.Text = creditNote.createdDate.ToString("d");
txtBox_issuedBy.Text = creditNote.issuedBy;
NetTotal_TextBlock.Text = creditNote.cost.ToString("C");
Vat_TextBlock.Text = creditNote.VAT.ToString("C");
TotalAmount_TextBlock.Text = creditNote.totalCost.ToString("C");
// Credit Note products
creditNoteProductsGrid.ItemsSource = creditNote.products;
}
else
{
MessageBox.Show("Credit Note with ID = " + creditNoteID + ", does not exist");
}
}
public async Task <bool> StoreNewCreditNoteAsync(int InvoiceId, CreditNote CreditNote)
{
CreditNote.InvoiceId = InvoiceId;
_context.CreditNotes.Add(CreditNote);
return((await _context.SaveChangesAsync()) > 0);
}
private async Task InvokeCreditNoteSP(CreditNoteDto creditNoteData, CreditNote res)
{
//Create the credit note number
await _dbCtx.Database.OpenConnectionAsync();
var connection = _dbCtx.Database.GetDbConnection();
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_Save_CreditNote";
command.Parameters.Add(new MySqlParameter("selectedIdCreditNote", creditNoteData.Id));
command.Parameters.Add(new MySqlParameter("selectedYear", creditNoteData.Year));
command.Parameters.Add(new MySqlParameter("issuedBy", new Guid(_claimPrincipal.Value.Identity.Name)));
var cnNum = (int?)command.ExecuteScalar();
await _dbCtx.Database.CloseConnectionAsync();
if (cnNum.HasValue)
{
var desc = "No error description avaialle";
if (cnNum.Value == 1062)
{
desc = "Duplicate credit note number!!";
}
_dbCtx.CreditNotes.Remove(res);
throw new Exception($"Unable to create ad store credit note number. ERR-NO={cnNum} {desc}");
}
}
protected void btnget_Click(object sender, EventArgs e)
{
Session["Datacn"] = null;
Session["Typ"] = null;
Session["Typ"] = "N";
string Selectedcn = "";
bool checkAll = false;
if (Chkbxlstcn.Items[0].Selected == true)
{
checkAll = true;
}
for (int i = 1; i < Chkbxlstcn.Items.Count; i++)
{
if (checkAll == true)
{
Selectedcn = Selectedcn + Chkbxlstcn.Items[i].Value.ToString() + ",";
}
else if (Chkbxlstcn.Items[i].Selected == true)
{
Selectedcn = Selectedcn + Chkbxlstcn.Items[i].Value.ToString() + ",";
}
}
// Selectedcn = Selectedcn ;
DataTable dt = new DataTable();
dt = CreditNote.Get_PrintCN_multiple(Convert.ToInt32(strFY), Selectedcn).Tables[0];
Session["Datacn"] = dt;
fillReport();
}
private void GSTPrint()
{
string Selectedcn = "";
bool checkAll = false;
if (Chkbxlstcn.Items[0].Selected == true)
{
checkAll = true;
}
for (int i = 1; i < Chkbxlstcn.Items.Count; i++)
{
if (checkAll == true)
{
Selectedcn = Selectedcn + Chkbxlstcn.Items[i].Value.ToString() + ",";
}
else if (Chkbxlstcn.Items[i].Selected == true)
{
Selectedcn = Selectedcn + Chkbxlstcn.Items[i].Value.ToString() + ",";
}
}
// Selectedcn = Selectedcn ;
DataTable dt = new DataTable();
dt = CreditNote.Get_PrintCN_multiple(Convert.ToInt32(strFY), Selectedcn).Tables[0];
Session["Datacn"] = dt;
if (Session["Datacn"] != null)
{
DataTable dt5 = new DataTable();
dt5 = (DataTable)Session["Datacn"];
ReportDocument CR = new ReportDocument();
CR.Load(Server.MapPath("Report/GSTCNPrint1.rpt"));
CR.SetDataSource(dt5);
Crptcnprint.ReportSource = CR;
}
}
internal static CreditNoteRefundList getCreditnoteRefundList(HttpResponseMessage responce)
{
var creditnoterefundList = new CreditNoteRefundList();
var jsonObj =
JsonConvert.DeserializeObject <Dictionary <string, object> >(responce.Content.ReadAsStringAsync().Result);
if (jsonObj.ContainsKey("creditnote_refunds"))
{
var refundsArray =
JsonConvert.DeserializeObject <List <object> >(jsonObj["creditnote_refunds"].ToString());
foreach (var refundObj in refundsArray)
{
var creditnote = new CreditNote();
creditnote = JsonConvert.DeserializeObject <CreditNote>(refundObj.ToString());
creditnoterefundList.Add(creditnote);
}
}
if (jsonObj.ContainsKey("page_context"))
{
var pageContext = new PageContext();
pageContext = JsonConvert.DeserializeObject <PageContext>(jsonObj["page_context"].ToString());
creditnoterefundList.page_context = pageContext;
}
return(creditnoterefundList);
}
public void Delete(CreditNote creditNote)
{
var creditNoteItem = testContext.CreditNote.Find(creditNote.CrNoteNo, creditNote.CrNoteDate, creditNote.ProductId, creditNote.OrderId, creditNote.OrderDate);
testContext.CreditNote.Remove(creditNoteItem);
testContext.SaveChanges();
}
public void SubmitChanges(CreditNote document, BasicConfig config)
{
int sequence = 0;
var envelope = new CommandEnvelope();
envelope.Initialize(document);
List<DocumentCommand> commandsToExecute = document.GetDocumentCommandsToExecute();
CreateCommand createCommand= commandsToExecute.OfType<CreateCommand>().FirstOrDefault();
if (createCommand != null)
envelope.CommandsList.Add(new CommandEnvelopeItem(++sequence, createCommand));
// _commandRouter.RouteDocumentCommand(createCommand);
List<AfterCreateCommand> lineItemCommands = commandsToExecute.OfType<AfterCreateCommand>().ToList();
foreach (var item in lineItemCommands)
{
envelope.CommandsList.Add(new CommandEnvelopeItem(++sequence, item));
//_commandRouter.RouteDocumentCommand(item);
}
ConfirmCreditNoteCommand confirmCreditNoteCommand = commandsToExecute.OfType<ConfirmCreditNoteCommand>().FirstOrDefault();
if (confirmCreditNoteCommand != null)
envelope.CommandsList.Add(new CommandEnvelopeItem(++sequence, confirmCreditNoteCommand));
// _commandRouter.RouteDocumentCommand(confirmCreditNoteCommand);
_commandEnvelopeRouter.RouteCommandEnvelope(envelope);
}
protected void Grd5_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
int rtqty5 = Convert.ToInt32(((Label)Grd5.Rows[e.NewEditIndex].FindControl("lbl5rtqty")).Text);
string BookCode5 = ((Label)Grd5.Rows[e.NewEditIndex].FindControl("lbl5bkcode")).Text;
string CustCode5 = ((Label)Grd5.Rows[e.NewEditIndex].FindControl("lbl5custcode")).Text;
GrdView.DataSource = CreditNote.Get_DC_CNBkview(Convert.ToInt32(strFY), CustCode5, BookCode5);
GrdView.DataBind();
if (rtqty5 != 0)
{
Pnl5CustDetails.Visible = true;
Pnl5.Visible = true;
PnlBkdetails.Visible = true;
Pnlview.Visible = true;
lbbkcode1.Text = ((Label)Grd5.Rows[e.NewEditIndex].FindControl("lbl5bkcode")).Text;
lbName1.Text = ((Label)Grd5.Rows[e.NewEditIndex].FindControl("lbl5Name")).Text;
}
else
{
Pnl5CustDetails.Visible = true;
Pnl5.Visible = true;
PnlBkdetails.Visible = false;
Pnlview.Visible = false;
}
}
catch
{
}
}
protected void btnget_Click(object sender, EventArgs e)
{
lblviewCNNo.Text = txtCnno.Text.Trim();
CNNo = Convert.ToInt32(txtCnno.Text.Trim());
// Bindgrdcn();
//grdcn.DataSource = CreditNote.PrintCN(CNNo);
//grdcn.DataBind();
DataSet grid = new DataSet();
grid = CreditNote.EditCN(Convert.ToInt32(strFY), CNNo);
grdBookDetails.DataSource = grid;
grdBookDetails.DataBind();
Session["tempDCData1"] = grid.Tables[0];
DataSet ds6 = new DataSet();
ds6 = CreditNote.PrintCN(Convert.ToInt32(strFY), CNNo);
if (ds6.Tables[1].Rows.Count > 0)
{
txtCNDate.Text = ds6.Tables[1].Rows[0]["CNDate"].ToString();
lblCustN.Text = ds6.Tables[1].Rows[0]["CustName"].ToString();
lbledit.Text = Convert.ToInt32(ds6.Tables[1].Rows[0]["IsEdit"]).ToString();
txtGCN.Text = ds6.Tables[1].Rows[0]["GCN"].ToString();
txtSCN.Text = ds6.Tables[1].Rows[0]["SCN"].ToString();
txtlRNO.Text = ds6.Tables[1].Rows[0]["LrNo"].ToString();
lbltransporter.Text = ds6.Tables[1].Rows[0]["TransportName"].ToString();
lblflagdc.Text = ds6.Tables[1].Rows[0]["Flag"].ToString();
CustCode = ds6.Tables[1].Rows[0]["CustCode"].ToString();
if (ds6.Tables[1].Rows[0]["IsExciseApplicable"].ToString() == "1")
{
ISExcise.Checked = true;
}
else
{
ISExcise.Checked = false;
}
}
if (lbledit.Text == "0")
{
btn_Save.Enabled = false;
btn_Save.BorderColor = System.Drawing.Color.Red;
btn_Save.ToolTip = "Record Editing Locked";
}
else
{
btn_Save.BorderColor = System.Drawing.Color.Green;
btn_Save.Enabled = true;
btn_Save.ToolTip = "";
}
btn_Save.Visible = true;
PnlAddbk.Visible = true;
PnlPrint.Visible = false;
btnPrint.Visible = false;
grdBookDetails.Focus();
//UpdatePanel1.Update();
}
public static CreditNoteDto ToDto(this CreditNote e, bool includeReceipt = false)
{
if (e == null)
{
return(null);
}
var res = new CreditNoteDto();
res.Id = e.Id;
res.Description = e.Description;
res.InvoiceNumber = e.InvoiceNumber;
res.CreditNoteNumber = e.CreditNoteNumber;
res.IdReceipt = e.IdReceipt;
res.InvoiceDate = e.InvoiceDate;
res.IssueDate = e.IssueDate;
res.IssuedBy = e.IssuedBy;
res.Owner = e.Owner != null?e.Owner.ToDto() : null;
if (includeReceipt)
{
res.PaymentReceipt = e.PaymentReceipt.ToDto();
}
return(res);
}
/// <summary>
/// Loads the credit note information on the page
/// </summary>
/// <param name="creditNoteId"></param>
public void loadCreditNote(int creditNoteId)
{
oldCreditNote = CreditNoteViewModel.getCreditNote(creditNoteId);
if (oldCreditNote != null)
{
// Customer details
textBox_Customer.Text = oldCreditNote.customer.CustomerName;
textBox_Contact_Details.Text = oldCreditNote.customer.PhoneNumber.ToString();
textBox_Email_Address.Text = oldCreditNote.customer.Email;
textBox_Address.Text = oldCreditNote.customer.Address + ", " + oldCreditNote.customer.City + ", " +
oldCreditNote.customer.Country;
// Invoice details
textBox_invoiceNumber.Text = oldCreditNote.idCreditNote.ToString();
txtbox_invoiceDate.Text = oldCreditNote.createdDate.ToString("d");
;
issuedBy.Text = oldCreditNote.issuedBy;
NetTotal_TextBlock.Text = oldCreditNote.cost.ToString("C");
Vat_TextBlock.Text = oldCreditNote.VAT.ToString("C");
TotalAmount_TextBlock.Text = oldCreditNote.totalCost.ToString("C");
foreach (var p in oldCreditNote.products)
{
ProductDataGrid.Items.Add(p);
}
comboBox_invoiceID.ItemsSource =
InvoiceViewModel.getCustomerInvoices(oldCreditNote.customer.idCustomer);
}
else
{
MessageBox.Show("Credit Note id doesnt't exist");
}
}
protected void btnget_Click(object sender, EventArgs e)
{
lblviewCNNo.Text = txtCnno.Text.Trim();
CNNo = Convert.ToInt32(txtCnno.Text.Trim());
DateTime cndate;
// Bindgrdcn();
grdcn.DataSource = CreditNote.PrintCN(Convert.ToInt32(strFY), CNNo);
grdcn.DataBind();
DataSet ds = new DataSet();
ds = CreditNote.PrintCN(Convert.ToInt32(strFY), CNNo);
if (ds.Tables[1].Rows.Count > 0)
{
lblCustName.Text = ds.Tables[1].Rows[0]["CustName"].ToString();
lblCustAddress.Text = ds.Tables[1].Rows[0]["Address"].ToString();
lblCNDate.Text = ds.Tables[1].Rows[0]["CNDate"].ToString();
}
PnlPrint.Visible = true;
btnDelete.Visible = true;
bool i = Global.ValidateDate(lblCNDate.Text.ToString());
if (i == true)
{
}
else
{
btnDelete.Visible = false;
lblAuditMsg.Text = "You cannot delete CN with CNDate Less than Audit CutOffDate:" + Session["AuditCutOffDate"].ToString();
}
}
public IDataResult <CreditNote> Add(CreditNote creditNote)
{
Random value = new Random();
creditNote.FindeksValue = value.Next(0, 1901);
_creditNoteDal.Add(creditNote);
return(new SuccessDataResult <CreditNote>(creditNote, Messages.Completed));
}
public void Update(CreditNote creditNote)
{
var creditNoteItem = testContext.CreditNote.Find(creditNote.CrNoteNo, creditNote.CrNoteDate, creditNote.ProductId, creditNote.OrderId, creditNote.OrderDate);
creditNoteItem.ModifiedBy = creditNote.ModifiedBy;
creditNoteItem.IsReturned = creditNote.IsReturned;
testContext.SaveChanges();
}
private CreditNote Map(tblDocument tblDoc)
{
var cn = new CreditNote(tblDoc.Id);
_Map(tblDoc, cn);
cn.InvoiceId = tblDoc.InvoiceOrderId == null ? Guid.Empty : tblDoc.InvoiceOrderId.Value;
cn._SetLineItems(tblDoc.tblLineItems.Select(n => MapCreditLineItem(n)).ToList());
return cn;
}
public TimeEntryListItemViewModel(CreditNote timeEntry, InvoiceListItemView invoice, IUserRepository userRepository, IDataService dataService)
{
_timeEntry = ConvertCreditNoteToTimeEntry(timeEntry);
_invoice = invoice;
_userRepository = userRepository;
_dataService = dataService;
ExcludeTimeEntryCommand = new DelegateCommand(ExecuteExcludeTimeEntry, () => TimeEntry.IsStopped);
}
public static CreditNote[] GetByInvoice(int invoice_id)
{
DataTable tbl = GetDataTableByInvoice(invoice_id);
CreditNote[] list = new CreditNote[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
list[i] = LoadAll(tbl.Rows[i]);
return list;
}
private Xero.Api.Core.Model.CreditNote CreateCreditNote(CreditNote CreditNote)
{
Xero.Api.Core.Model.CreditNote xeroCreditNote = new Xero.Api.Core.Model.CreditNote
{
Number = CreditNote.No,
Date = CreditNote.TransactionDate,
Type = Xero.Api.Core.Model.Types.CreditNoteType.AccountsPayable,
Status = Xero.Api.Core.Model.Status.InvoiceStatus.Authorised,
Reference = CreditNote.ReferenceNumber,
CurrencyCode = CreditNote.Currency.Value,
SubTotal = (decimal)CreditNote.SubTotalExcl,
TotalTax = (decimal)CreditNote.VATTotal,
Total = (decimal)CreditNote.TotalIncl,
Contact = XeroFunctions.CoreApi().Contacts.Find(CreditNote.Vendor.AccountingPartnerIdentifier)
};
CreditNote.AccountingPartnerIdentifier = xeroCreditNote.Id.ToString();
if (xeroCreditNote.Contact == null)
{
xeroCreditNote.Contact = new Xero.Api.Core.Model.Contact()
{
Name = CreditNote.Vendor.FullName,
IsCustomer = true,
FirstName = CreditNote.Vendor.FirstName,
LastName = CreditNote.Vendor.LastName,
TaxNumber = CreditNote.Vendor.VATNo,
EmailAddress = CreditNote.Vendor.Email,
ContactNumber = CreditNote.Vendor.CellNo,
AccountNumber = CreditNote.Vendor.ExternalAccountsCode
};
CreditNote.Vendor.AccountingPartnerIdentifier = xeroCreditNote.Contact.Id.ToString();
}
foreach (WorkflowItem workflowItem in CreditNote.Items)
{
if (xeroCreditNote.LineItems == null)
{
xeroCreditNote.LineItems = new List <Xero.Api.Core.Model.LineItem>();
}
Xero.Api.Core.Model.LineItem lineItem = new Xero.Api.Core.Model.LineItem()
{
Description = workflowItem.Description,
Quantity = (decimal)workflowItem.Quantity,
UnitAmount = (decimal)workflowItem.SellingPrice,
TaxAmount = (decimal)workflowItem.VATTotal,
LineAmount = (decimal)workflowItem.TotalIncl
};
xeroCreditNote.LineItems.Add(lineItem);
workflowItem.AccountingPartnerIdentifier = lineItem.LineItemId.ToString();
}
return(xeroCreditNote);
}
protected void btngetcust_Click(object sender, EventArgs e)
{
Pnl2.Visible = false;
PnlAddbk.Visible = false;
btn_Save.Visible = false;
PnlPrint.Visible = false;
btnPrint.Visible = false;
frdate = txtFromDate.Text.Split('/')[2] + "/" + txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0];
todate = txttoDate.Text.Split('/')[2] + "/" + txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0];
fdt = Convert.ToDateTime(frdate);
tdt = Convert.ToDateTime(todate);
if (tdt >= fdt)
{
if (RdbtnSelect.SelectedValue == "CN")
{
Pnl1.Visible = false;
RptrCN2.DataSource = CreditNote.GetCNNo_Bydt(Convert.ToInt32(strFY), fdt, tdt);
RptrCN2.DataBind();
RptrCN2.Visible = true;
// RptrCN2.Visible = true;
PnlPrint.Visible = false;
Pnl2.Visible = true;
PnlAddbk.Visible = false;
}
if (RdbtnSelect.SelectedValue == "CustomerwiseCN")
{
DataSet ds = new DataSet();
ds = CreditNote.GetCustlist_Bydt(Convert.ToInt32(strFY), fdt, tdt);
if (ds.Tables[0].Rows.Count > 0)
{
DDLCustomer.DataSource = CreditNote.GetCustlist_Bydt(Convert.ToInt32(strFY), fdt, tdt);
DDLCustomer.DataBind();
DDLCustomer.Items.Insert(0, new ListItem("-Select Customer-", "0"));
Pnl1.Visible = true;
}
else
{
MessageBox("Records Not Available ");
}
}
}
else
{
MessageBox("From Date is greater than To Date");
}
//else
//if (Convert.ToDateTime(todate) == Convert.ToDateTime(frdate))
//{
// MessageBox("From Date and To Date are similar");
//}
DDLCustomer.Focus();
}
public int UpdateRefundToCustomer(RefundToCustomerForm psForm)
{
try
{
using (SDNSalesDBEntities entities = new SDNSalesDBEntities())
{
foreach (var item in psForm.RefundToCustomerDetails)
{
CashAndBankTransaction obj = entities.CashAndBankTransactions.Where(e => e.Cash_Cheque_No == psForm.RefundToCustomer.CashChequeNo &&
e.SO_CN_PO_DN_No == item.SalesNo).SingleOrDefault();
if (obj != null)
{
obj.Acc_Id = psForm.RefundToCustomer.AccountId;
obj.Amount = psForm.RefundToCustomer.Amount;
obj.Cash_Cheque_No = psForm.RefundToCustomer.CashChequeNo;
obj.Cash_Cheque_Date = psForm.RefundToCustomer.Date;
obj.Remarks = psForm.RefundToCustomer.Remarks;
obj.Is_Cheque = psForm.RefundToCustomer.IsCheque;
//saving details entity
obj.SO_CN_PO_DN_No = item.SalesNo;
obj.SO_CN_PO_DN_Date = item.SalesDate;
obj.SO_CN_PO_DN_Amt = item.SalesAmount;
obj.Amt_Due = obj.Amt_Due = item.AmountDue - item.AmountAdjusted;
obj.Amt_Refunded = item.AmountAdjusted;
obj.Discount = item.Discount;
obj.UpdatedBy = 0;
obj.UpdatedDate = DateTime.Now;
entities.SaveChanges();
if (item.AmountDue == 0 && item.AmountAdjusted == item.SalesAmount)
{
CreditNote dn = entities.CreditNotes.Where(e => e.CN_No == item.SalesNo).SingleOrDefault();
SalesOrder order = entities.SalesOrders.Where(e => e.SO_No == item.SalesNo).SingleOrDefault();
if (dn != null)
{
dn.CN_Status = Convert.ToByte(DN_Status.Refunded);
entities.SaveChanges();
}
else if (order != null)
{
order.SO_Status = Convert.ToByte(PO_Status.Refunded);
entities.SaveChanges();
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(psForm.RefundToCustomer.ID);
}
public static Result <Invoice> ApplyCreditNote(Invoice invoice, CreditNote creditNoteToApply, out CreditNote creditNote)
{
creditNote = creditNoteToApply;
if (!string.IsNullOrEmpty(invoice.AppliedCreditNote))
{
if (creditNoteToApply == null)
{
return(new Result <Invoice>(-1, -1, $"creditNoteNotExist_msg | {invoice.AppliedCreditNote}"));
}
if (creditNoteToApply.Applied)
{
return(new Result <Invoice>(-1, -1, $"creditNoteApplied_msg | {invoice.AppliedCreditNote},{creditNoteToApply.ModifiedByName}"));
}
if (creditNoteToApply.CurrencyId != invoice.CurrencyId)
{
return(new Result <Invoice>(-1, -1, $"differentCurrency_msg | {invoice.AppliedCreditNote},{creditNoteToApply.ModifiedByName}"));
}
if (creditNoteToApply.Amount > invoice.TotalAmount)
{
return(new Result <Invoice>(-1, -1, "amountIsGreater_msg"));
}
creditNoteToApply.Applied = true;
creditNoteToApply.ModifiedBy = invoice.CreatedBy;
creditNoteToApply.ModifiedDate = DateTime.Now;
creditNoteToApply.AppliedInvoiceNumber = invoice.InvoiceNumber;
creditNote = creditNoteToApply;
invoice.AppliedCreditNote = creditNoteToApply.Sequence;
invoice.AppliedCreditNoteAmount = creditNoteToApply.Amount;
invoice.PaidAmount += creditNoteToApply.Amount;
// invoice.OwedAmount -= creditNoteToApply.Amount;
invoice.OwedAmount = invoice.OwedAmount < 0 ? 0 : invoice.OwedAmount;
// Invoice.MontoAdeudado -= creditNoteToApply.Monto;
//invoice.InvoiceLeads.ForEach(d =>
//{
// decimal porcentajeNC = (d.TotalAmount / invoice.TotalAmount) / d.Quantity;
// d.CreditNoteAmount = porcentajeNC * creditNoteToApply.Amount;
//});
return(new Result <Invoice>(0, 0, "ok_msg", new List <Invoice>()
{
invoice
}));
}
return(new Result <Invoice>(0, 0, "ok_msg", new List <Invoice>()
{
invoice
}));;
}
/// <summary>
/// Given the credit note object inserts it in to the database
/// </summary>
/// <param name="creditNote"></param>
public static void insertCreditNote(CreditNote creditNote)
{
try
{
//insert invoice
var query =
"INSERT INTO CreditNote (idCreditNote, idCustomer, Cost, Vat, TotalCost, CreatedDate, PreviousBalance, IssuedBy) Values (@idCreditNote, @idCustomer, @Cost, @Vat, @TotalCost, @CreatedDate, @PreviousBalance, @IssuedBy)";
using (var cmd = new MySqlCommand(query, conn))
{
// Now we can start using the passed values in our parameters:
cmd.Parameters.AddWithValue("@idCreditNote", creditNote.idCreditNote);
cmd.Parameters.AddWithValue("@idCustomer", creditNote.customer.idCustomer);
cmd.Parameters.AddWithValue("@Cost", creditNote.cost);
cmd.Parameters.AddWithValue("@Vat", creditNote.VAT);
cmd.Parameters.AddWithValue("@TotalCost", creditNote.totalCost);
cmd.Parameters.AddWithValue("@CreatedDate", creditNote.createdDate);
cmd.Parameters.AddWithValue("@IssuedBy", creditNote.issuedBy);
cmd.Parameters.AddWithValue("@PreviousBalance", creditNote.customer.Balance);
// Execute the query
cmd.ExecuteNonQuery();
}
//insert product
var sCommand =
new StringBuilder(
"INSERT INTO CreditNoteProduct (idCreditNote, idProduct, idInvoice, Quantity) VALUES ");
var Rows = new List <string>();
foreach (var p in creditNote.products)
{
Rows.Add(string.Format("('{0}','{1}','{2}','{3}')",
MySqlHelper.EscapeString(creditNote.idCreditNote.ToString()),
p.idProduct, MySqlHelper.EscapeString(p.productInvoiceID.ToString()), p.Quantity));
using (var cmd3 = new MySqlCommand("UPDATE Product SET Stock = REPLACE(Stock,Stock,Stock+" +
p.Quantity + ") WHERE idProduct=" + p.idProduct + ";", conn))
{
cmd3.ExecuteNonQuery();
}
}
sCommand.Append(string.Join(",", Rows));
sCommand.Append(";");
using (var myCmd = new MySqlCommand(sCommand.ToString(), conn))
{
myCmd.CommandType = CommandType.Text;
myCmd.ExecuteNonQuery();
}
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
public Allocation Allocate(CreditNote creditNote, Allocation allocation)
{
string requestXml = ModelSerializer.Serialize(allocation);
string responseXml = _proxy.ApplyAllocation(creditNote, requestXml);
Response response = ModelSerializer.DeserializeTo <Response>(responseXml);
return(response.GetTypedProperty <Allocation>().First());
}
/// <summary>
/// Updates an existing credit note.
/// </summary>
/// <param name="creditnote_id">The creditnote_id is the identifier of the creditnote.</param>
/// <param name="update_info">The update_info is the Creditnote object which is having the updation details.</param>
/// <param name="parameters">The parameters is the dictionary object which is having the optional parameters.<br></br>Those are<br></br>
/// <table>
/// <tr><td>ignore_auto_number_generation</td><td>Ignore auto number generation for this credit note only. On enabling this option credit note number is mandatory.</td></tr>
/// </table>
/// </param>
/// <returns>Creditnote object.</returns>
public CreditNote Update(string creditnote_id, CreditNote update_info, Dictionary <object, object> parameters)
{
string url = baseAddress + "/" + creditnote_id;
var json = JsonConvert.SerializeObject(update_info);
parameters.Add("JSONString", json);
var responce = ZohoHttpClient.put(url, getQueryParameters(parameters));
return(CreditNoteParser.getCreditnote(responce));
}
/// <summary>
/// Creates a credit note for a customer..
/// </summary>
/// <param name="new_creditnote_info">
/// The new_creditnote_info is the Creditnote object which contains the information to
/// create a new creditnote with customer_id as mandatory parameter.
/// </param>
/// <param name="parameters">
/// The parameters is the dictionary object which is having the optional parameters to the new creditnote.<br></br>
/// Those are listed below<br></br>
/// <table>
/// <tr>
/// <td>invoice_id</td><td>Create a credit note and apply it to an invoice.</td>
/// </tr>
/// <tr>
/// <td>ignore_auto_number_generation</td>
/// <td>
/// Ignore auto number generation for this credit note only. On enabling this option credit note number is
/// mandatory.
/// </td>
/// </tr>
/// </table>
/// </param>
/// <returns>Creditnote object.</returns>
public CreditNote Create(CreditNote new_creditnote_info, Dictionary <object, object> parameters)
{
var url = baseAddress;
var json = JsonConvert.SerializeObject(new_creditnote_info);
parameters.Add("JSONString", json);
var responce = ZohoHttpClient.post(url, getQueryParameters(parameters));
return(CreditNoteParser.getCreditnote(responce));
}
public static CreditNote LoadAll(DataRow row)
{
CreditNote creditNote = Load(row);
creditNote.Staff = StaffDB.Load(row, "staff_");
creditNote.Staff.Person = PersonDB.Load(row, "person_");
creditNote.Staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr");
return(creditNote);
}
public IActionResult Add(CreditNote creditNote)
{
var result = _creditNoteService.Add(creditNote);
if (result.Success)
{
return(Ok(result));
}
return(BadRequest(result));
}
/// <summary>
/// Refund credit note amount.
/// </summary>
/// <param name="creditnote_id">The creditnote_id is the identifier of the crditnote.</param>
/// <param name="refund_details">The refund_details is the Creditnote object which is having the refund details with date and amount parameters as mandatory.</param>
/// <returns>Creditnote object.</returns>
public CreditNote AddRefund(string creditnote_id, CreditNote refund_details)
{
string url = baseAddress + "/" + creditnote_id + "/refunds";
var json = JsonConvert.SerializeObject(refund_details);
var jsonstring = new Dictionary <object, object>();
jsonstring.Add("JSONString", json);
var responce = ZohoHttpClient.post(url, getQueryParameters(jsonstring));
return(CreditNoteParser.getCreditnoteRefund(responce));
}
public Document CreateDocument(Guid id, DocumentType documentType, CostCentre documentIssuerCC, CostCentre documentRecipientCC, User documentIssuerUser, string DocumentReference, double? longitude=null, double? latitude=null)
{
Document doc = null;
switch (documentType)
{
case DocumentType.Order:
doc = new Order(id);
doc = Map(doc, documentType, documentIssuerCC, documentRecipientCC, /*null, */documentIssuerUser, DocumentReference, longitude, latitude);
break;
case DocumentType.DispatchNote://
doc = new DispatchNote(id);
doc = Map(doc, documentType, documentIssuerCC, documentRecipientCC, /*null, */documentIssuerUser, DocumentReference, longitude, latitude);
break;
case DocumentType.Receipt:
doc = new Receipt(id);
doc = Map(doc, documentType, documentIssuerCC, documentRecipientCC, documentIssuerUser, DocumentReference, longitude, latitude);
break;
case DocumentType.DisbursementNote:
doc = new DisbursementNote(id);
doc = Map(doc, documentType, documentIssuerCC, documentRecipientCC, documentIssuerUser, DocumentReference, longitude, latitude);
break;
case DocumentType.CreditNote:
doc = new CreditNote(id);
doc = Map(doc, documentType, documentIssuerCC, documentRecipientCC, documentIssuerUser, DocumentReference, longitude, latitude);
break;
case DocumentType.ReturnsNote:
doc = new ReturnsNote(id);
doc = Map(doc, documentType, documentIssuerCC, documentRecipientCC, documentIssuerUser, DocumentReference, longitude, latitude);
break;
case DocumentType.PaymentNote:
doc = new PaymentNote(id);
doc = Map(doc, documentType, documentIssuerCC, documentRecipientCC, documentIssuerUser, DocumentReference, longitude, latitude);
break;
}
return doc;
}
public string ApplyAllocation(CreditNote creditNote, string requestXml)
{
throw new NotImplementedException();
}
public static CreditNote[] GetByInvoiceIDs(int[] invoice_ids)
{
string sql = JoinedSql + (invoice_ids != null && invoice_ids.Length > 0 ? " WHERE invoice_id IN (" + string.Join(",", invoice_ids) + ")" : " WHERE 1<>1");
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
CreditNote[] ret = new CreditNote[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
ret[i] = LoadAll(tbl.Rows[i]);
return ret;
}
public string ApplyAllocation(CreditNote creditNote, string body)
{
EnforceRateLimit();
return _innerIntegrationProxy.ApplyAllocation(creditNote, body);
}
public string ApplyAllocation(CreditNote creditNote, string body)
{
Uri uri = ConstructChildResourceUri(_oauthSession.ConsumerContext.BaseEndpointUri, "CreditNotes", creditNote.CreditNoteID.ToString(), "Allocations", null);
IConsumerRequest oauthRequest = _oauthSession.Request()
.ForMethod("PUT")
.WithAcceptHeader(MimeTypes.TextXml)
.ForUri(uri)
.SignWithToken()
.WithBody(body);
var consumerResponse = oauthRequest.ToConsumerResponse();
// Check for <ApiException> response message
if (consumerResponse.Content.StartsWith("<ApiException"))
{
ApiExceptionDetails details = ModelSerializer.DeserializeTo<ApiExceptionDetails>(consumerResponse.Content);
throw new ApiException(details);
}
return consumerResponse.Content;
}
public ValidationResultInfo Validate(CreditNote itemToValidate)
{
return _Validate(itemToValidate);
}
public void SubmitToWF(CreditNote creditNote)
{
_confirmCreditNoteWfManager.SubmitChanges(creditNote, null);
}
public void ConfirmCommandCN()
{
SaveCommandCN();
if (note != null)
{
using (StructureMap.IContainer c = NestedContainer)
{
BasicConfig config = c.GetInstance<IConfigService>().Load();
Using<IConfirmCreditNoteWFManager>(c).SubmitChanges(note,config);
note = null;
ClearViewModel();
MessageBox.Show("Credit Note Issued Succesful");
}
}
else
{
throw new Exception("Save first ");
}
}
public void SaveCommandCN()
{
using (StructureMap.IContainer c = NestedContainer)
{
note = new CreditNote(Guid.NewGuid());
note.DocumentDateIssued = DateTime.Now;
note.DocumentIssuerCostCentre = Using<ICostCentreRepository>(c).GetById(Using<IConfigService>(c).Load().CostCentreId);
note.DocumentIssuerCostCentreApplicationId = Using<IConfigService>(c).Load().CostCentreApplicationId;
note.DocumentIssuerUser = Using<IUserRepository>(c).GetById(Using<IConfigService>(c).ViewModelParameters.CurrentUserId);
note.DocumentRecipientCostCentre = Using<ICostCentreRepository>(c).GetById( Using<IConfigService>(c).Load().CostCentreId);
note.DocumentReference = "";
note.InvoiceId = InvoiceNo;
note.DocumentType = DocumentType.InventoryTransferNote;
List<CreditNoteLineItem> ListitnLineitem = new List<CreditNoteLineItem>();
//foreach (EditCNItemsViewModel item in LineItems)
//{
CreditNoteLineItem itnLineitem = new CreditNoteLineItem(Guid.NewGuid())
{
Description = Description,
LineItemSequenceNo = 0,
LineItemVatValue = LineItemVatValue,
Product = Using<IProductRepository>(c).GetById(ProductId),
Qty = Qty,
IsNew = true,
Value = Value
};
ListitnLineitem.Add(itnLineitem);
//}
note._SetLineItems(ListitnLineitem);
}
}
public void AddToCreditNote(CreditNote creditNote)
{
base.AddObject("CreditNote", creditNote);
}
public static CreditNote CreateCreditNote(int creditNoteID)
{
CreditNote creditNote = new CreditNote();
creditNote.CreditNoteID = creditNoteID;
return creditNote;
}
