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);
}
