private GST_TRN_CRDR_NOTE GetCRDRNote(DataRow item, string SupplierGSTIN, byte p, string UserId)
{
GST_TRN_CRDR_NOTE note = new GST_TRN_CRDR_NOTE();
if (p == 3)
{
note.GST_TRN_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, p, UserId);
note.CDN_Date = item.Field <DateTime?>("Column2");
note.NoteType = (byte)(item.ItemArray[5].ToString() == "C" ? 0 : 1);
note.P_Gst = (byte)(item.ItemArray[12].ToString() == "Y" ? 1 : 0);
note.TotalNoteValue = Convert.ToDecimal(item.ItemArray[8].ToString());
note.Description = item.Field <string>("Column6");
note.NoteNumber = item.ItemArray[3].ToString();
note.From_UserID = note.GST_TRN_INVOICE.SellerUserID;
note.To_UserID = note.GST_TRN_INVOICE.ReceiverUserID;
note.CreatedBy = UserId;
}
else if (p == 4)
{
note.GST_TRN_INVOICE = GetInvoiceInformation(item, SupplierGSTIN, p, UserId);
note.CDN_Date = item.Field <DateTime?>("Column2");
note.NoteType = (byte)(item.ItemArray[3].ToString() == "C" ? 0 : 1);
note.P_Gst = (byte)(item.ItemArray[12].ToString() == "Y" ? 1 : 0);
note.TotalNoteValue = Convert.ToDecimal(item.ItemArray[8].ToString());
note.Description = item.Field <string>("Column6");
note.NoteNumber = item.ItemArray[1].ToString();
note.From_UserID = note.GST_TRN_INVOICE.SellerUserID;
note.To_UserID = note.GST_TRN_INVOICE.ReceiverUserID;
note.CreatedBy = UserId;
}
unitOfWork.CreditDebitNoteRepository.Create(note);
unitOfWork.Save();
return(note);
}
private B2b b2bData(GST_TRN_CRDR_NOTE crdrNote)
{
B2b clsb2b = new B2b();
/// clsb2b.ctin = crdrNote.
return(clsb2b);
}
/// <summary>
///
/// </summary>
/// <param name="itemData"></param>
/// <returns></returns>
public bool UpdateNote(GST_TRN_CRDR_NOTE itemData)
{
try
{
unitOfWork.CreditDebitNoteRepository.Update(itemData);
unitOfWork.Save();
return(true);
}
catch (Exception ex)
{ return(false); }
}
public Cdnr Getcdnrdata(GST_TRN_CRDR_NOTE cdnrInvoice)
{
Cdnr cdnrdatas = new Cdnr();
cdnrdatas.ctin = "Tin";//cdnrInvoice.TIN;
cdnrdatas.nt = new List <Nt>();
foreach (var data in cdnrInvoice.GST_TRN_CRDR_NOTE_DATA)
{
cdnrdatas.nt.Add(GetNt(data));
}
return(cdnrdatas);
}
//public List<GST_TRN_CRDR_NOTE> GetCDNGroup(string userID)
//{
// var item = unitOfWork.CreditDebitNoteRepository.Filter(f => f.From_UserID == userID).GroupBy(g => g.NoteType).ToList();
// return item;
//}
/// <summary>
///
/// </summary>
/// <param name="itemID"></paramt>
/// <returns></returns>
public GST_TRN_CRDR_NOTE GetCreditDebitNote(Int64 itemID)
{
GST_TRN_CRDR_NOTE itcItem = new GST_TRN_CRDR_NOTE();
try
{
itcItem = unitOfWork.CreditDebitNoteRepository.Find(f => f.CreditDebitID == itemID);
}
catch (Exception ex)
{ }
return(itcItem);
}
public Cdnur Getcdnurdata(GST_TRN_CRDR_NOTE cdnurdata)
{
Cdnur cdnur = new Cdnur();
cdnur.idt = Convert.ToDateTime(cdnurdata.GST_TRN_INVOICE.InvoiceDate).ToString("dd-mm-yyyy");
cdnur.inum = cdnurdata.GST_TRN_INVOICE.InvoiceNo;
cdnur.nt_dt = Convert.ToDateTime(cdnurdata.GST_TRN_INVOICE.InvoiceDate).ToString("dd-mm-yyyy");
cdnur.nt_num = cdnurdata.GST_TRN_INVOICE.InvoiceNo;
cdnur.ntty = Convert.ToString(cdnurdata.NoteType);
cdnur.p_gst = Convert.ToString(cdnurdata.P_Gst);
//cdnur.rsn = Convert.ToString(cdnurdata.Issuing_Note);
//cdnur.val = Convert.ToInt32(cdnurdata.Voucher_Value);
cdnur.itms = new List <Itm6>();
foreach (var data in cdnurdata.GST_TRN_CRDR_NOTE_DATA)
{
cdnur.itms.Add(GetItem6(data));
}
return(cdnur);
}
/// <summary>
///
/// </summary>
/// <param name="invoice"></param>
/// <param name="note"></param>
/// <returns></returns>
private GST_TRN_CRDR_NOTE RefectorNote(GST_TRN_INVOICE invoice)
{
GST_TRN_CRDR_NOTE item = new GST_TRN_CRDR_NOTE();
item.From_UserID = invoice.SellerUserID;
item.To_UserID = invoice.ReceiverUserID;
item.InvoiceID = invoice.InvoiceID;
item.NoteTypeStatus = (byte)EnumConstants.NoteTypeStatus.Fresh;
item.CDN_Date = DateTime.Now;
item.NoteType = this.NoteType;
item.Description = this.Description;
string noteNo = "";
if ((EnumConstants.NoteType) this.NoteType == EnumConstants.NoteType.Credit)
{
noteNo = "CR" + UniqueNoGenerate.RandomValueNote();
}
else if ((EnumConstants.NoteType) this.NoteType == EnumConstants.NoteType.Debit)
{
noteNo = "DR" + UniqueNoGenerate.RandomValueNote();
}
else
{
noteNo = UniqueNoGenerate.RandomValueNote();
}
item.NoteNumber = noteNo;
item.CreatedBy = invoice.SellerUserID;
item.CreatedDate = DateTime.Now;
List <GST_TRN_CRDR_NOTE_DATA> data = new List <GST_TRN_CRDR_NOTE_DATA>();
foreach (GST_TRN_INVOICE_DATA invData in invoice.GST_TRN_INVOICE_DATA)
{
data.Add(ItemData(invData));
}
item.GST_TRN_CRDR_NOTE_DATA = data;
return(item);
}
