public static void CreateJournalForOfflineAgentCollection(int companyId, List <OfflineAgentDetails> agentlist) { try { CRSDAL dal = null; string strErr = ""; for (int i = 0; i < agentlist.Count; i++) { if (strErr == "") { OfflineAgentDetails 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_docnumber", agentlist[i].Docnumber, 300, ParameterDirection.Input); dal.AddParameter("p_TotalAmount", agentlist[i].TotalFare, ParameterDirection.Input); dal.AddParameter("p_ClassID", agentlist[i].ClassID, ParameterDirection.Input); dal.AddParameter("p_NetAmount", agentlist[i].NetAmount, ParameterDirection.Input); dal.AddParameter("p_AgentComm", agentlist[i].AgentComm, ParameterDirection.Input); dal.AddParameter("p_GST", agentlist[i].GST, ParameterDirection.Input); dal.AddParameter("p_Discount", agentlist[i].Discount, ParameterDirection.Input); // dal.AddParameter("p_narration", narration, 3000, ParameterDirection.Input); int status = dal.ExecuteDML("spKabraTallySet_OfflineAgentCollection_Test", CommandType.StoredProcedure, 0, ref strErr); if (strErr != "") { throw new Exception(); } EntryCounter.GetInstance().AddCount(1); } catch (Exception ex) { Logger.WriteLog("OfflineAgentCollection", "CreateJournalForOfflineAgentCollection", " Error for Agent: " + agentlist[i].AgentName + " " + ex.Message); Logger.WriteLogAlert2("OfflineAgentCollection" + "CreateJournalForOfflineAgentCollection" + " Error for Agent: " + agentlist[i].AgentName + " " + ex.Message); PostingAPI.UpdatePostingStatusForException(companyId, agentlist[i].JourneyDate, 9); } } } } catch (Exception ex) { Logger.WriteLog("OfflineAgentCollection", "CreateJournalForOfflineAgentCollection", ex.Message); Logger.WriteLogAlert("OfflineAgentCollection" + "CreateJournalForOfflineAgentCollection" + ex.Message); } }
public static string GetNarration(OfflineAgentDetails av) { string narration = ""; try { narration = "BUS TICKET COLLECTION ON DT. " + av.bookingDate.ToString("dd-MM-yyyy") + " THROUGH: " + av.AgentName; } catch (Exception ex) { Logger.WriteLog("AccountingUtil", "GetNarration", "Failed for AGENTID : " + av.AgentId + "Error: " + ex.Message); } return(narration); }
public static List <OfflineAgentDetails> GetOfflineAgentCollection(int companyid, DateTime journeyDate) { List <OfflineAgentDetails> AgentList = new List <OfflineAgentDetails>(); try { string strErr = ""; CRSDAL dal = new CRSDAL(); dal.AddParameter("p_companyId", companyid, ParameterDirection.Input); dal.AddParameter("p_journeyDate", journeyDate, ParameterDirection.Input); DataSet dsOutPut = dal.ExecuteSelect("spKabraTallyGet_OfflineAgentCollection", CommandType.StoredProcedure, 0, ref strErr, "p_ErrMessage", false, "", false); if (dsOutPut != null && dsOutPut.Tables != null && dsOutPut.Tables.Count > 0) { DataTable dtOutput = dsOutPut.Tables[0]; if (dtOutput != null && dtOutput.Rows != null && dtOutput.Rows.Count > 0) { for (int i = 0; i < dtOutput.Rows.Count; i++) { DataRow dr = dtOutput.Rows[i]; OfflineAgentDetails ac = new OfflineAgentDetails(); ac.AgentName = dr["agentname"].ToString(); ac.AgentId = Convert.ToInt32(dr["agentid"].ToString()); ac.BusId = Convert.ToInt32(dr["busid"].ToString()); ac.DebitLedgerId = Convert.ToInt32(dr["DebitLedgerId"].ToString()); ac.CreditLedgerId = Convert.ToInt32(dr["CreditLedgerId"].ToString()); ac.NetAmount = Convert.ToDecimal(dr["NetAmt"].ToString()); ac.GST = Convert.ToDecimal(dr["GST"].ToString()); ac.Discount = Convert.ToDecimal(dr["Discount"].ToString()); ac.TotalFare = Convert.ToDecimal(dr["TotalFare"].ToString()); ac.AgentComm = Convert.ToDecimal(dr["AgentComm"].ToString()); ac.JourneyDate = Convert.ToDateTime(dr["journeydate"].ToString()); ac.Docnumber = Convert.ToString(dr["docnumber"].ToString()); ac.ClassName = dr["classname"].ToString(); ac.ClassID = Convert.ToInt32(dr["ClassID"].ToString()); AgentList.Add(ac); } } } } catch (Exception ex) { Logger.WriteLog("OfflineAgentAPI", "GetOfflineAgentCollection", ex.Message); } return(AgentList); }