internal DataTable LoadFinancialYear(OpeningBlcTransferModel ObjOpeningBlcTransferModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPFinancialYear"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOpeningBlcTransferModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOpeningBlcTransferModel.OrgID); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtFinancialYear = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtFinancialYear); dtFinancialYear.TableName = "success"; } catch (Exception) { dtFinancialYear = new DataTable(); dtFinancialYear.TableName = "error"; return(dtFinancialYear); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtFinancialYear); }
internal DataTable SaveOpeningBalance(OpeningBlcTransferModel ObjOpeningBlcTransferModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPFinancialYear"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOpeningBlcTransferModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOpeningBlcTransferModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjOpeningBlcTransferModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCode", ObjOpeningBlcTransferModel.YrCode); ClsCon.cmd.Parameters.AddWithValue("@VChType", ObjOpeningBlcTransferModel.DocTypeID); ClsCon.cmd.Parameters.AddWithValue("@YrStartDate", ObjOpeningBlcTransferModel.YrStartDate); ClsCon.cmd.Parameters.AddWithValue("@DocDate", ObjOpeningBlcTransferModel.VoucharDate); ClsCon.cmd.Parameters.AddWithValue("@VoucherNo", ObjOpeningBlcTransferModel.VoucharNo); ClsCon.cmd.Parameters.AddWithValue("@Narration", ObjOpeningBlcTransferModel.Narration); ClsCon.cmd.Parameters.AddWithValue("@ClosingStock", ObjOpeningBlcTransferModel.ClosingStock); ClsCon.cmd.Parameters.AddWithValue("@IP", ObjOpeningBlcTransferModel.IP); ClsCon.cmd.Parameters.AddWithValue("@User", ObjOpeningBlcTransferModel.User); ClsCon.cmd.Parameters.AddWithValue("@TblOpeningBlc", JsonConvert.DeserializeObject <DataTable>(ObjOpeningBlcTransferModel.dtOpeningBlc)); //ClsCon.cmd.Parameters.AddWithValue("@TblOpeningBlc", ObjOpeningBlcTransfer.dtOpeningBlc); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtFinancialYear = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtFinancialYear); dtFinancialYear.TableName = "success"; } catch (Exception) { dtFinancialYear = new DataTable(); dtFinancialYear.TableName = "error"; return(dtFinancialYear); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtFinancialYear); }
internal DataTable ItemDetails(OpeningBlcTransferModel ObjOpeningBlcTransfer) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPFinancialYear"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOpeningBlcTransfer.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOpeningBlcTransfer.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjOpeningBlcTransfer.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCode", ObjOpeningBlcTransfer.YrCode); ClsCon.cmd.Parameters.AddWithValue("@IP", ObjOpeningBlcTransfer.IP); ClsCon.cmd.Parameters.AddWithValue("@UserID", ObjOpeningBlcTransfer.User); ClsCon.cmd.Parameters.AddWithValue("@EntryDate", ObjOpeningBlcTransfer.EntryDate); ClsCon.cmd.Parameters.AddWithValue("@TblItemTransferDetail", JsonConvert.DeserializeObject <DataTable>(ObjOpeningBlcTransfer.dtItemDetail)); //ClsCon.cmd.Parameters.AddWithValue("@TblItemTransferDetail", ObjOpeningBlcTransfer.dtItemDetail); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtFinancialYear = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtFinancialYear); dtFinancialYear.TableName = "success"; } catch (Exception) { dtFinancialYear = new DataTable(); dtFinancialYear.TableName = "error"; return(dtFinancialYear); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtFinancialYear); }
internal DataTable SaveFinancialYear(OpeningBlcTransferModel ObjOpeningBlcTransferModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPFinancialYear"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOpeningBlcTransferModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOpeningBlcTransferModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjOpeningBlcTransferModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCode", ObjOpeningBlcTransferModel.YrCode); ClsCon.cmd.Parameters.AddWithValue("@YearFromTo", ObjOpeningBlcTransferModel.YearFromTo); ClsCon.cmd.Parameters.AddWithValue("@ActiveID", ObjOpeningBlcTransferModel.ActiveID); ClsCon.cmd.Parameters.AddWithValue("@UserID", ObjOpeningBlcTransferModel.UserID); ClsCon.cmd.Parameters.AddWithValue("@IPAddress", ObjOpeningBlcTransferModel.IPAddress); ClsCon.cmd.Parameters.AddWithValue("@YrStartDate", ObjOpeningBlcTransferModel.YrStartDate); ClsCon.cmd.Parameters.AddWithValue("@YrEndDate", ObjOpeningBlcTransferModel.YrEndDate); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtFinancialYear = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtFinancialYear); dtFinancialYear.TableName = "success"; } catch (Exception) { dtFinancialYear = new DataTable(); dtFinancialYear.TableName = "error"; return(dtFinancialYear); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtFinancialYear); }
internal DataTable LoadClosingBalance(OpeningBlcTransferModel ObjOpeningBlcTransfer) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPRPTtrialBalance"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOpeningBlcTransfer.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOpeningBlcTransfer.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjOpeningBlcTransfer.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCode", ObjOpeningBlcTransfer.YrCode); ClsCon.cmd.Parameters.AddWithValue("@VoucharDateFrom", ObjOpeningBlcTransfer.VoucharDateFrom); ClsCon.cmd.Parameters.AddWithValue("@VoucharDateto", ObjOpeningBlcTransfer.VoucharDateto); ClsCon.cmd.Parameters.AddWithValue("@Reportorder", ObjOpeningBlcTransfer.Reportorder); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtClosingBlc = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtClosingBlc); dtClosingBlc.TableName = "success"; } catch (Exception) { dtClosingBlc = new DataTable(); dtClosingBlc.TableName = "error"; return(dtClosingBlc); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtClosingBlc); }
public DataTable ItemDetails(OpeningBlcTransferModel ObjOpeningBlcTransfer) { DataTable dtAmountModel = ObjBudgetYearActivationDA.ItemDetails(ObjOpeningBlcTransfer); return(dtAmountModel); }
public DataTable TrasferItemOpeningBlc(OpeningBlcTransferModel ObjOpeningBlcTransfer) { DataTable dtAmountModel = ObjBudgetYearActivationDA.TrasferItemOpeningBlc(ObjOpeningBlcTransfer); return(dtAmountModel); }
public DataTable SaveOpeningBalance(OpeningBlcTransferModel ObjOpeningBlcTransfer) { DataTable dtAmountModel = ObjBudgetYearActivationDA.SaveOpeningBalance(ObjOpeningBlcTransfer); return(dtAmountModel); }
public DataTable LoadFinancialYear(OpeningBlcTransferModel ObjOpeningBlcTransferModel) { DataTable dtAmountModel = ObjBudgetYearActivationDA.LoadFinancialYear(ObjOpeningBlcTransferModel); return(dtAmountModel); }
public DataTable SaveOpeningBalance(OpeningBlcTransferModel ObjOpeningBlcTransfer) { DataTable ClosingBlcList = ObjOpeningBlcTransferDA.SaveOpeningBalance(ObjOpeningBlcTransfer); return(ClosingBlcList); }