public static void InsertUpdateCostCentresInCRS(List <Ledger> CostcenterList, int companyId)
{
try
{
if (CostcenterList != null && CostcenterList.Count > 0)
{
for (int i = 0; i < CostcenterList.Count; i++)
{
Logger.WriteLog("Ledger Name: " + CostcenterList[i].LedgerName);
CRSDAL dal = new CRSDAL();
string strErr = "";
dal.AddParameter("p_classname", CostcenterList[i].LedgerName, 200, ParameterDirection.Input);
dal.AddParameter("p_issubclass", 0, ParameterDirection.Input);
dal.AddParameter("p_parentclassid", 0, ParameterDirection.Input);
dal.AddParameter("p_CompanyId", companyId, ParameterDirection.Input);
dal.AddParameter("p_accsysid", CostcenterList[i].LedgerMasterID, 50, ParameterDirection.Input);
dal.AddParameter("p_parentname", "", 200, ParameterDirection.Input);
int status = dal.ExecuteDML("spTallySet_CostCentre", CommandType.StoredProcedure, 0, ref strErr);
}
}
}
catch (Exception ex)
{
Logger.WriteLog("MastersAPI", "InsertUpdateCostCentresInCRS", ex.Message);
}
}
public static void CreateJournalForOnlineAgentCollection(int companyId, List <OnlineAgentDetails> agentlist)
{
try
{
CRSDAL dal = null;
string strErr = "";
for (int i = 0; i < agentlist.Count; i++)
{
if (strErr == "")
{
OnlineAgentDetails al = agentlist[i];
// string narration = AccountingUtil.GetNarration(al);
try
{
dal = new CRSDAL();
dal.AddParameter("p_CompanyID", companyId, ParameterDirection.Input);
dal.AddParameter("p_JourneyDate", agentlist[i].JourneyDate, ParameterDirection.Input);
dal.AddParameter("p_DebitLedgerId", agentlist[i].DebitLedgerId, ParameterDirection.Input);
dal.AddParameter("p_CreditLedgerId", agentlist[i].CreditLedgerId, ParameterDirection.Input);
dal.AddParameter("p_ClassID", agentlist[i].ClassID, ParameterDirection.Input);
dal.AddParameter("p_TotalAmount", agentlist[i].TotalFare, ParameterDirection.Input);
dal.AddParameter("p_docnumber", agentlist[i].Docnumber, 300, ParameterDirection.Input);
dal.AddParameter("p_AgentComm", agentlist[i].AgentComm, ParameterDirection.Input);
dal.AddParameter("p_NetAmount", agentlist[i].NetAmount, ParameterDirection.Input);
dal.AddParameter("p_GST", agentlist[i].GST, ParameterDirection.Input);
dal.AddParameter("p_Discount", agentlist[i].Discount, ParameterDirection.Input);
int status = dal.ExecuteDML("spKabraTallySet_OnlineAgentCollection_Test", CommandType.StoredProcedure, 0, ref strErr);
if (strErr != "")
{
throw new Exception();
}
EntryCounter.GetInstance().AddCount(1);
}
catch (Exception ex)
{
Logger.WriteLog("OnlineAgentAPI", "CreateJournalForOnlineAgentCollection", " Error for Agent: " + agentlist[i].AgentName + " " + ex.Message);
Logger.WriteLogAlert2("OnlineAgentAPI" + "CreateJournalForOnlineAgentCollection" + " Error for Agent: " + agentlist[i].AgentName + " " + ex.Message);
PostingAPI.UpdatePostingStatusForException(companyId, agentlist[i].JourneyDate, 9);
}
}
}
}
catch (Exception ex)
{
Logger.WriteLog("OnlineAgentAPI", "CreateJournalForOnlineAgentCollection", ex.Message);
Logger.WriteLogAlert("OnlineAgentAPI" + "CreateJournalForOnlineAgentCollection" + ex.Message);
}
}
public static void CreateSaleForBusWiseCollection(int companyId, List <BusWise> BusWiseCollectionList)
{
try
{
CRSDAL dal = null;
string strErr = "";
for (int i = 0; i < BusWiseCollectionList.Count; i++)
{
//BusWise bc = BusWiseCollectionList[i];
//string narration = AccountingUtil.GetNarration(bc);
decimal totalamount = 0;
decimal totalColl = 0;
totalamount = BusWiseCollectionList[i].NetAmount - (BusWiseCollectionList[i].SGST + BusWiseCollectionList[i].CGST + BusWiseCollectionList[i].BusComm);
totalColl = totalamount + BusWiseCollectionList[i].SGST + BusWiseCollectionList[i].CGST + BusWiseCollectionList[i].BusComm + BusWiseCollectionList[i].OfflineAgentComm + BusWiseCollectionList[i].OnlineAgentComm;
try
{
dal = new CRSDAL();
dal.AddParameter("p_CompanyID", companyId, ParameterDirection.Input);
dal.AddParameter("p_JourneyDate", BusWiseCollectionList[i].JourneyDate, ParameterDirection.Input);
dal.AddParameter("p_AccsysledgerId", BusWiseCollectionList[i].AccsysLedgerId, ParameterDirection.Input);
dal.AddParameter("p_CommLedgerId", BusWiseCollectionList[i].CommLedgerId, ParameterDirection.Input);
dal.AddParameter("p_NetAmount", totalamount, ParameterDirection.Input);
dal.AddParameter("p_TotalAmount", totalColl, ParameterDirection.Input);
dal.AddParameter("p_Comm", BusWiseCollectionList[i].BusComm, ParameterDirection.Input);
dal.AddParameter("p_GST", BusWiseCollectionList[i].CGST, ParameterDirection.Input);
dal.AddParameter("p_TotalOfflineAgentComm", BusWiseCollectionList[i].OfflineAgentComm, ParameterDirection.Input);
dal.AddParameter("p_TotalOnlineAgentComm", BusWiseCollectionList[i].OnlineAgentComm, ParameterDirection.Input);
dal.AddParameter("p_docnumber", BusWiseCollectionList[i].DocNumber, 1000, ParameterDirection.Input);
// dal.AddParameter("p_narration", narration, 3000, ParameterDirection.Input);
int status = dal.ExecuteDML("spJainTallySet_BusCollection", CommandType.StoredProcedure, 0, ref strErr);
EntryCounter.GetInstance().AddCount(1);
}
catch (Exception ex)
{
Logger.WriteLog("BusWiseCollection", "CreateSaleForBusWiseCollection", " Error for Bus: " + BusWiseCollectionList[i].BusiD + " " + ex.Message);
}
}
}
catch (Exception ex)
{
Logger.WriteLog("BusWiseCollection", "CreateSaleForBusWiseCollection", ex.Message);
}
}
public static void CreateSaleForFranchiseCollection(int companyId, List <Franchise> FranchiseCollectionList)
{
try
{
CRSDAL dal = null;
string strErr = "";
for (int i = 0; i < FranchiseCollectionList.Count; i++)
{
if (strErr == "")
{
Franchise fv = FranchiseCollectionList[i];
string narration = AccountingUtil.GetNarration(fv);
try
{
dal = new CRSDAL();
dal.AddParameter("p_CompanyID", companyId, ParameterDirection.Input);
dal.AddParameter("p_JourneyDate", FranchiseCollectionList[i].JourneyDate, ParameterDirection.Input);
dal.AddParameter("p_DebitLedgerId", FranchiseCollectionList[i].DebitLedgerId, ParameterDirection.Input);
dal.AddParameter("p_CreditLedgerId", FranchiseCollectionList[i].CreditLedgerId, ParameterDirection.Input);
dal.AddParameter("p_NetAmount", FranchiseCollectionList[i].NetAmount, ParameterDirection.Input);
dal.AddParameter("p_TotalAmount", FranchiseCollectionList[i].TotalAmt, ParameterDirection.Input);
dal.AddParameter("p_GST", FranchiseCollectionList[i].ServiceTax, ParameterDirection.Input);
dal.AddParameter("p_docnumber", FranchiseCollectionList[i].DocNumber, 300, ParameterDirection.Input);
dal.AddParameter("p_ClassID", FranchiseCollectionList[i].ClassID, ParameterDirection.Input);
dal.AddParameter("p_AgentComm", FranchiseCollectionList[i].AggentComm, ParameterDirection.Input);
dal.AddParameter("p_Discount", FranchiseCollectionList[i].Discount, ParameterDirection.Input);
int status = dal.ExecuteDML("spKabraTallySet_FranchiseBooking_Test", CommandType.StoredProcedure, 0, ref strErr);
if (strErr != "")
{
throw new Exception();
}
EntryCounter.GetInstance().AddCount(1);
}
catch (Exception ex)
{
Logger.WriteLog("FranchiseCollection", "CreateSaleForFranchiseCollection", " Error for Franchise: " + FranchiseCollectionList[i].FranchiseName + " " + ex.Message);
Logger.WriteLogAlert2("FranchiseCollection" + "CreateSaleForFranchiseCollection" + " Error for Franchise: " + FranchiseCollectionList[i].FranchiseName + " " + ex.Message);
PostingAPI.UpdatePostingStatusForException(companyId, FranchiseCollectionList[i].JourneyDate, 9);
}
}
}
}
catch (Exception ex)
{
Logger.WriteLog("FranchiseCollection", "CreateSaleForFranchiseCollection", ex.Message);
Logger.WriteLogAlert("FranchiseCollection" + "CreateSaleForFranchiseCollection" + ex.Message);
}
}
public static void CreateJournalForUserWiseCollection(int companyId, List <Booking> bookingsList)
{
try
{
CRSDAL dal = new CRSDAL();
string strErr = "";
for (int i = 0; i < bookingsList.Count; i++)
{
Booking b = bookingsList[i];
if (strErr == "")
{
try
{
dal = new CRSDAL();
dal.AddParameter("p_CompanyID", companyId, ParameterDirection.Input);
dal.AddParameter("p_JourneyDate", bookingsList[i].JourneyDate, ParameterDirection.Input);
dal.AddParameter("p_DebitLedgerId", bookingsList[i].DebitLedgerId, ParameterDirection.Input);
dal.AddParameter("p_CreditLedgerId", bookingsList[i].CreditLedgerId, ParameterDirection.Input);
dal.AddParameter("p_ClassID", bookingsList[i].ClassId, ParameterDirection.Input);
dal.AddParameter("p_TotalAmount", bookingsList[i].TotalAmount, ParameterDirection.Input);
dal.AddParameter("p_NetAmount", bookingsList[i].NetAmount, ParameterDirection.Input);
dal.AddParameter("p_GST", bookingsList[i].GST, ParameterDirection.Input);
dal.AddParameter("p_docnumber", bookingsList[i].DocNumber, 300, ParameterDirection.Input);
int status = dal.ExecuteDML("spKabraTallySet_BranchCollection_Test", CommandType.StoredProcedure, 0, ref strErr);
EntryCounter.GetInstance().AddCount(1);
if (strErr != "")
{
throw new Exception();
}
}
catch (Exception ex)
{
Logger.WriteLog("BookingAPI", "CreateJournalForUserWiseCollection", " Error for Branch: " + bookingsList[i].BranchName + " " + ex.Message);
Logger.WriteLogAlert2("BookingAPI " + "Error:CreateJournalForUserWiseCollection For JournalID: " + bookingsList[i].BranchName + " " + ex.Message);
PostingAPI.UpdatePostingStatusForException(companyId, bookingsList[i].JourneyDate, 9);
}
}
}
}
catch (Exception ex)
{
Logger.WriteLog("BookingAPI", "CreateJournalForUserWiseCollection", ex.Message);
Logger.WriteLogAlert("BookingAPI" + "CreateJournalForUserWiseCollection" + ex.Message);
}
}
public static void CreateSaleForGSTBoookingCollection(int companyId, List <GSTBooking> gstbookingsList)
{
try
{
CRSDAL dal = null;
string strErr = "";
decimal roundoff = 0;
for (int i = 0; i < gstbookingsList.Count; i++)
{
dal = new CRSDAL();
GSTBooking gb = gstbookingsList[i];
string narration = AccountingUtil.GetNarration(gb);
string description = AccountingUtil.GetDescription(gb);
roundoff = gstbookingsList[i].TotalFare - gstbookingsList[i].NetFare;
dal.AddParameter("p_CompanyID", companyId, ParameterDirection.Input);
dal.AddParameter("p_BookingDate", gstbookingsList[i].BookingDate, ParameterDirection.Input);
dal.AddParameter("p_debitledgerid", gstbookingsList[i].DebitLedgerId, ParameterDirection.Input);
dal.AddParameter("p_creditledgerid", gstbookingsList[i].CreditLedgerId, ParameterDirection.Input);
dal.AddParameter("p_basefare", gstbookingsList[i].BaseFare, ParameterDirection.Input);
dal.AddParameter("p_totalfare", gstbookingsList[i].NetFare, ParameterDirection.Input);
dal.AddParameter("p_GST", gstbookingsList[i].GST, ParameterDirection.Input);
dal.AddParameter("p_IGST", gstbookingsList[i].IGST, ParameterDirection.Input);
dal.AddParameter("p_comm", gstbookingsList[i].Comm, ParameterDirection.Input);
dal.AddParameter("p_narration", narration, 3000, ParameterDirection.Input);
dal.AddParameter("p_description", description, 3000, ParameterDirection.Input);
dal.AddParameter("p_docnumber", gstbookingsList[i].DocNumber, 3000, ParameterDirection.Input);
dal.AddParameter("p_doctype", gstbookingsList[i].DocType, 3000, ParameterDirection.Input);
dal.AddParameter("p_roundoff", roundoff, ParameterDirection.Input);
int status = dal.ExecuteDML("spTallySet_BranchGSTBooking", CommandType.StoredProcedure, 0, ref strErr);
EntryCounter.GetInstance().AddCount(1);
}
}
catch (Exception ex)
{
Logger.WriteLog("UserWise", "CreateSaleForUserWiseCollection", ex.Message);
}
}
public static void InsertPostingStatus(int companyId, List <PostingJob> postinglist)
{
try
{
CRSDAL dal = new CRSDAL();
string strErr = "";
// DateTime BookingDate = Convert.ToDateTime(BookingDateTo);
for (int i = 0; i < postinglist.Count; i++)
{
PostingJob p = postinglist[i];
try
{
dal = new CRSDAL();
dal.AddParameter("p_CompanyId", companyId, ParameterDirection.Input);
dal.AddParameter("p_JourneyDate", postinglist[i].JourneyDate, ParameterDirection.Input);
dal.AddParameter("p_JobId", postinglist[i].JobId, ParameterDirection.Input);
dal.AddParameter("p_StatusId", postinglist[i].StatusId, ParameterDirection.Input);
dal.AddParameter("p_Remarks", postinglist[i].Remarks, 200, ParameterDirection.Input);
dal.AddParameter("p_UserId", 0, ParameterDirection.Input);
dal.AddParameter("p_ErrMsg", "", 100, ParameterDirection.Output);
int status = dal.ExecuteDML("spTallySet_PostingStatus", CommandType.StoredProcedure, 0, ref strErr);
if (strErr != "")
{
Logger.WriteLog("", "", "Error while upating posting status for CompanyId: " + companyId + "JourneyDate: " + postinglist[i].JourneyDate + " JobId: " + postinglist[i].JobId + " StatusId: " + postinglist[i].StatusId + " Error Is: " + strErr);
}
}
catch (Exception ex)
{
Logger.WriteLog("BookingAPI", "InsertPostingStatus", " Error for JourneyDate: " + postinglist[i].JourneyDate + " " + ex.Message);
Logger.WriteLogAlert("BookingAPI " + "Error:InsertPostingStatus For JourneyDate: " + postinglist[i].JourneyDate + " " + ex.Message);
}
}
}
catch (Exception ex)
{
Logger.WriteLog("PostingStatusAPI", "InsertPostingStatus", ex.Message);
}
}
public static void CreateSaleForFranchiseCollection(int companyId, List <Franchise> FranchiseCollectionList)
{
try
{
CRSDAL dal = null;
string strErr = "";
for (int i = 0; i < FranchiseCollectionList.Count; i++)
{
Franchise fv = FranchiseCollectionList[i];
string narration = AccountingUtil.GetNarration(fv);
try
{
dal = new CRSDAL();
dal.AddParameter("p_CompanyID", companyId, ParameterDirection.Input);
dal.AddParameter("p_BookingDate", FranchiseCollectionList[i].Bookingdate, ParameterDirection.Input);
dal.AddParameter("p_DebitLedgerId", FranchiseCollectionList[i].DebitLedgerId, ParameterDirection.Input);
dal.AddParameter("p_CreditLedgerId", FranchiseCollectionList[i].CreditLedgerId, ParameterDirection.Input);
dal.AddParameter("p_NetAmount", FranchiseCollectionList[i].NetAmount, ParameterDirection.Input);
dal.AddParameter("p_TotalAmount", FranchiseCollectionList[i].TotalAmt, ParameterDirection.Input);
dal.AddParameter("p_ServiceTax", FranchiseCollectionList[i].ServiceTax, ParameterDirection.Input);
dal.AddParameter("p_narration", narration, 3000, ParameterDirection.Input);
dal.AddParameter("p_docnumber", FranchiseCollectionList[i].DocNumber, 300, ParameterDirection.Input);
int status = dal.ExecuteDML("spTallySet_FranchiseCollectionJain", CommandType.StoredProcedure, 0, ref strErr);
EntryCounter.GetInstance().AddCount(1);
}
catch (Exception ex)
{
Logger.WriteLog("FranchiseCollection", "CreateSaleForFranchiseCollection", " Error for Branch: " + FranchiseCollectionList[i].FranchiseId + " " + ex.Message);
}
}
}
catch (Exception ex)
{
Logger.WriteLog("FranchiseCollection", "CreateSaleForFranchiseCollection", ex.Message);
}
}
public static void InsertUpdateLedgersInCRS(List <Ledger> ledgerList, int companyId)
{
try
{
if (ledgerList != null && ledgerList.Count > 0)
{
for (int i = 0; i < ledgerList.Count; i++)
{
Logger.WriteLog("Ledger Name: " + ledgerList[i].LedgerName);
CRSDAL dal = new CRSDAL();
string strErr = "";
dal.AddParameter("p_ledgerid", 0, ParameterDirection.Input);
dal.AddParameter("p_ledgername", ledgerList[i].LedgerName, 200, ParameterDirection.Input);
dal.AddParameter("p_LedgerTypeId", 0, ParameterDirection.Input);
dal.AddParameter("p_LedgerSubTypeId", 0, ParameterDirection.Input);
dal.AddParameter("p_CompanyId", companyId, ParameterDirection.Input);
dal.AddParameter("p_accsysid", ledgerList[i].LedgerMasterID, 50, ParameterDirection.Input);
dal.AddParameter("p_parentname", ledgerList[i].LedgerParentName, 200, ParameterDirection.Input);
int status = dal.ExecuteDML("spTallySet_Ledger_20171003_utkarsh", CommandType.StoredProcedure, 0, ref strErr);
if (strErr != "")
{
Logger.WriteLog("MastersAPI", "NoInsertUpdateLedgersInCRS", ledgerList[i].LedgerName);
}
else
{
//Logger.WriteLog("MastersAPI", "InsertUpdateLedgersInCRS", ledgerList[i].LedgerName);
}
}
}
}
catch (Exception ex)
{
Logger.WriteLog("MastersAPI", "InsertUpdateLedgersInCRS", ex.Message);
}
}
public static void UpdatePostingStatus(PostingJob pJob)
{
try
{
CRSDAL dal = new CRSDAL();
string strErr = "";
dal.AddParameter("p_CompanyId", pJob.CompanyId, ParameterDirection.Input);
dal.AddParameter("p_JourneyDate", pJob.JourneyDate, ParameterDirection.Input);
dal.AddParameter("p_JobId", pJob.JobId, ParameterDirection.Input);
dal.AddParameter("p_StatusId", pJob.StatusId, ParameterDirection.Input);
dal.AddParameter("p_Remarks", pJob.Remarks, 200, ParameterDirection.Input);
dal.AddParameter("p_UserId", 0, ParameterDirection.Input);
dal.AddParameter("p_ErrMsg", "", 100, ParameterDirection.Output);
int status = dal.ExecuteDML("spTallySet_PostingStatus", CommandType.StoredProcedure, 0, ref strErr);
if (strErr != "")
{
Logger.WriteLog("", "", "Error while upating posting status for CompanyId: " + pJob.CompanyId + "JourneyDate: " + pJob.JourneyDate.ToString("yyyy-MM-dd") + " JobId: " + pJob.JobId + " StatusId: " + pJob.StatusId + " Error Is: " + strErr);
}
}
catch (Exception ex)
{
Logger.WriteLog("PostingStatusAPI", "UpdatePostingStatus", ex.Message);
}
}
public static void CreateCreditForCancellationdata(int companyId, List<Cancellation> CancellationList)
{
CRSDAL dal = null;
try
{
string strErr = "";
for (int i = 0; i < CancellationList.Count; i++)
{
if (CancellationList[i].DebitLedgerId > 0 && CancellationList[i].CreditLedgerId > 0)
{
Cancellation c = CancellationList[i];
string description = AccountingUtil.GetDescription(c);
try
{
dal = new CRSDAL();
dal.AddParameter("p_CompanyID", companyId, ParameterDirection.Input);
dal.AddParameter("p_CancelDate", CancellationList[i].CancelDate, ParameterDirection.Input);
dal.AddParameter("p_DebitLedgerId", CancellationList[i].DebitLedgerId, ParameterDirection.Input);
dal.AddParameter("p_CreditLedgerId", CancellationList[i].CreditLedgerId, ParameterDirection.Input);
dal.AddParameter("p_RefundAmt", CancellationList[i].RefundAmount, ParameterDirection.Input);
dal.AddParameter("p_TotalAmount", CancellationList[i].BaseFare, ParameterDirection.Input);
dal.AddParameter("p_GST", CancellationList[i].GST, ParameterDirection.Input);
dal.AddParameter("p_IGST", CancellationList[i].IGST, ParameterDirection.Input);
dal.AddParameter("p_Comm", CancellationList[i].Comm, ParameterDirection.Input);
dal.AddParameter("p_BookingId", CancellationList[i].BookingId, ParameterDirection.Input);
dal.AddParameter("p_TicketNo", CancellationList[i].TicketNo, 3000, ParameterDirection.Input);
dal.AddParameter("p_description", description, 3000, ParameterDirection.Input);
dal.AddParameter("p_docnumber", CancellationList[i].Docnumber, 3000, ParameterDirection.Input);
dal.AddParameter("p_doctype", CancellationList[i].DocType, 3000, ParameterDirection.Input);
int status = dal.ExecuteDML("spTallySet_CancellationJain", CommandType.StoredProcedure, 0, ref strErr);
EntryCounter.GetInstance().AddCount(1);
//if (strErr != "")
//{
// Logger.WriteLogAlert("Cancellation " + " Error for Bookigid: " + CancellationList[i].BookingId );
// break;
//}
}
catch (Exception ex)
{
Logger.WriteLog("Cancellation", "CreateCreditForCancellationdata", " Error for Bookigid: " + CancellationList[i].BookingId + " " + ex.Message);
Logger.WriteLogAlert("Cancellation " + " Error for Bookigid: " + CancellationList[i].BookingId + " " + ex.Message);
}
}
}
}
catch (Exception ex)
{
Logger.WriteLog("Cancellation", "CreateCreditForCancellationdata", ex.Message);
}
}
