internal DataTable CheckyecodeData(OpeningBalanceModel ObjOpeningBalanceModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPBudgetOpningBlc";
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOpeningBalanceModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOpeningBalanceModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjOpeningBalanceModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCode", ObjOpeningBalanceModel.yrcd);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtOpningBalance = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtOpningBalance);
dtOpningBalance.TableName = "success";
}
catch (Exception)
{
dtOpningBalance = new DataTable();
dtOpningBalance.TableName = "error";
return(dtOpningBalance);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtOpningBalance);
}
private DataTable checkExistingEntry()
{
objOpeningBalance = new OpeningBalanceModel();
objOpeningBalance.Ind = 2;//check yrcode acording companyId,BranchID and YearCode
objOpeningBalance.yrcd = GlobalSession.BudgetYrCD;
objOpeningBalance.OrgID = GlobalSession.OrgID;
objOpeningBalance.BrID = GlobalSession.BrID;
uri = string.Format("OpeningBalance/CheckyrCode");
DataTable dtOpeningBalance = CommonCls.ApiPostDataTable(uri, objOpeningBalance);
if (dtOpeningBalance.Rows.Count > 0)
{
txtCurrentBudgetAmt.Text = dtOpeningBalance.Rows[0]["CurrentBudgetAmt"].ToString();
txtPreviousYearBudgetAmt.Text = dtOpeningBalance.Rows[0]["PreviousYearBudgetAmt"].ToString();
txtPreviousYearActualAmt.Text = dtOpeningBalance.Rows[0]["PreviousYearActualAmt"].ToString();
txtPreviousYear2ActualAmt.Text = dtOpeningBalance.Rows[0]["PreviousYear2ActualAmt"].ToString();
// ShowMessage("Record Save successfully.", true);
hfOpeningBalID.Value = "0";
}
else
{
//ShowMessage("Record not Save successfully.", false);
}
return(dtOpeningBalance);
}
public HttpResponseMessage EditOpeningBalance([FromBody] OpeningBalanceModel oParty)
{
partyRepository.EditOpeningBalance(oParty);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Opening Balance Updated successfully"
}, formatter));
}
public bool SetClientOpeningBalance(OpeningBalanceModel model)
{
long maxSl = GetMaxOpeningBalanceRefNoOfCurrentYear();
model.OpeningRef = GenerateOpeningBalanceRef(maxSl);
int rowAffected = _iAccountGateway.SetClientOpeningBalance(model);
return(rowAffected > 0);
}
public ActionResult GetOpeningBalance()
{
OpeningBalanceModel lstOpeningBalance = GetGroupOpeningBalance();
ViewBag.GroupName = GroupInfo.GroupName;
bool isGroup = GroupInfo != null && GroupInfo.GroupID > 1;
ViewBag.isGroup = isGroup;
return(View(lstOpeningBalance));
}
public bool EditOpeningBalance(OpeningBalanceModel OpeningBalanceModel)
{
var ptable =
_entities.party_journal.Where(w => w.party_id == OpeningBalanceModel.party_id).FirstOrDefault();
ptable.opening_balance = OpeningBalanceModel.opening_balance;
ptable.closing_balance = OpeningBalanceModel.opening_balance;
_entities.SaveChanges();
return(true);
}
public OpeningBalanceModel GetGroupOpeningBalance()
{
List <OpeningBalanceModelAssets> lstassets = new List <OpeningBalanceModelAssets>();
List <OpeningBalanceModelLiabilities> lstliabilities = new List <OpeningBalanceModelLiabilities>();
OpeningBalanceModel OpeningBalances = new OpeningBalanceModel();
SqlCommand cmd = new SqlCommand("[usp_Group_OpeningBalance_Report]", con);
cmd.Parameters.Add(new SqlParameter("@GroupId", GroupInfo.GroupID));
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
con.Open();
OpeningBalances = new OpeningBalanceModel();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
OpeningBalanceModelLiabilities liabilities = new OpeningBalanceModelLiabilities();
liabilities.LiabilitiesAHID = Convert.ToInt32(dr["ahid"]);
liabilities.LiabilitiesAHCode = Convert.ToString(dr["AHCode"]);
liabilities.LiabilitiesAHName = Convert.ToString(dr["AHName"]);
liabilities.LiabilitiesOpeningBalance = Convert.ToDouble(dr["OpeningBalance"]);
OpeningBalances.LiabilitiesTotal += liabilities.LiabilitiesOpeningBalance;
lstliabilities.Add(liabilities);
}
if (dr.NextResult())
{
while (dr.Read())
{
OpeningBalanceModelAssets assets = new OpeningBalanceModelAssets();
assets.AssetAHID = Convert.ToInt32(dr["ahid"]);
assets.AssetAHCode = Convert.ToString(dr["AHCode"]);
assets.AssetAHName = Convert.ToString(dr["AHName"]);
assets.AssetOpeningBalance = Convert.ToDouble(dr["OpeningBalance"]);
OpeningBalances.AssetTotal += assets.AssetOpeningBalance;
lstassets.Add(assets);
}
}
OpeningBalances.openingBalanceModelAssets = lstassets;
OpeningBalances.openingBalanceModelLiabilities = lstliabilities;
return(OpeningBalances);
}
public ActionResult SetOpeningBalance(OpeningBalanceModel model)
{
try
{
var user = (ViewUser)Session["user"];
model.UserId = user.UserId;
if (model.TransactionType.Equals("Cr"))
{
model.Amount = model.Amount * -1;
}
bool result = _iAccountsManager.SetClientOpeningBalance(model);
if (result)
{
ModelState.Clear();
}
return(View());
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
};
}
// protected void btnclear_Click(object sender, EventArgs e)
// {
// txtCurrentBudgetAmt.Focus();
// ClearAll();
//}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtCurrentBudgetAmt.Text) || Convert.ToDecimal(txtCurrentBudgetAmt.Text) <= 0)
{
ShowMessage("Enter " + lblOBalBg1718.Text + " .", false);
txtCurrentBudgetAmt.Focus();
return;
}
//if (System.Text.RegularExpressions.Regex.IsMatch(txtCurrentBudgetAmt.Text, "[^0-9]"))
//{
// ShowMessage("Please enter only numbers.", false);
// txtCurrentBudgetAmt.Text = txtCurrentBudgetAmt.Text.Remove(txtCurrentBudgetAmt.Text.Length - 1);
// txtCurrentBudgetAmt.Focus();
// return;
//}
//if (System.Text.RegularExpressions.Regex.IsMatch(txtPreviousYearBudgetAmt.Text, "[^0-9]"))
//{
// ShowMessage("Please enter only numbers.", false);
// txtPreviousYearBudgetAmt.Text = txtPreviousYearBudgetAmt.Text.Remove(txtPreviousYearBudgetAmt.Text.Length - 1);
// txtPreviousYearBudgetAmt.Focus();
// return;
//}
//if (System.Text.RegularExpressions.Regex.IsMatch(txtPreviousYearActualAmt.Text, "[^0-9]"))
//{
// ShowMessage("Please enter only numbers.", false);
// txtPreviousYearActualAmt.Text = txtPreviousYearActualAmt.Text.Remove(txtPreviousYearActualAmt.Text.Length - 1);
// txtPreviousYearActualAmt.Focus();
// return;
//}
//if (System.Text.RegularExpressions.Regex.IsMatch(txtPreviousYear2ActualAmt.Text, "[^0-9]"))
//{
// ShowMessage("Please enter only numbers.", false);
// txtPreviousYear2ActualAmt.Text = txtPreviousYear2ActualAmt.Text.Remove(txtPreviousYear2ActualAmt.Text.Length - 1);
// txtPreviousYear2ActualAmt.Focus();
// return;
//}
if (string.IsNullOrEmpty(txtPreviousYearBudgetAmt.Text))
{
txtPreviousYearBudgetAmt.Text = "0";
//ShowMessage(lblOBalBg1617.Text, false);
//txtPreviousYearBudgetAmt.Focus();
//return;
}
if (string.IsNullOrEmpty(txtPreviousYearActualAmt.Text))
{
txtPreviousYearActualAmt.Text = "0";
//ShowMessage(lblOBalAc1617.Text, false);
//txtPreviousYearActualAmt.Focus();
//return;
}
if (string.IsNullOrEmpty(txtPreviousYear2ActualAmt.Text))
{
txtPreviousYear2ActualAmt.Text = "0";
//ShowMessage(lblOBalAc1516.Text, false);
//txtPreviousYear2ActualAmt.Focus();
//return;
}
objOpeningBalance = new OpeningBalanceModel();
objOpeningBalance.OrgID = GlobalSession.OrgID;
objOpeningBalance.BrID = GlobalSession.BrID;
objOpeningBalance.yrcd = GlobalSession.BudgetYrCD;
objOpeningBalance.CurrentBudgetAmt = Convert.ToDecimal(txtCurrentBudgetAmt.Text);
objOpeningBalance.PreviousYearBudgetAmt = Convert.ToDecimal(txtPreviousYearBudgetAmt.Text);
objOpeningBalance.PreviousYearActualAmt = Convert.ToDecimal(txtPreviousYearActualAmt.Text);
objOpeningBalance.PreviousYear2ActualAmt = Convert.ToDecimal(txtPreviousYear2ActualAmt.Text);
if (hfOpeningBalID.Value == "0")
{
objOpeningBalance.Ind = 1;//For Saving Data
uri = string.Format("OpeningBalance/SaveOpeningBalance");
}
//else
//{
// objOpeningBalance.Ind = 2;//For Update Data
// //objOpeningBalance.SectionID = CommonCls.ConvertIntZero(hfSectionID.Value);
// uri = string.Format("OpeningBalance/UpdateBudgetSection");
//}
DataTable dtOpeningBalance = CommonCls.ApiPostDataTable(uri, objOpeningBalance);
if (dtOpeningBalance.Rows.Count > 0)
{
ShowMessage("Record Save successfully.", true);
// ClearAll();
hfOpeningBalID.Value = "0";
//BindAll();
}
else
{
ShowMessage("Record not Save successfully.", false);
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, false);
}
}
public DataTable CheckyrCode(OpeningBalanceModel ObjOpeningBalanceModel)
{
DataTable SectionList = ObjOpningBalanceDA.CheckyecodeData(ObjOpeningBalanceModel);
return(SectionList);
}
public DataTable SaveOpeningBalance(OpeningBalanceModel ObjOpeningBalanceModel)
{
DataTable SectionList = ObjOpningBalanceDA.SaveOpningBalance(ObjOpeningBalanceModel);
return(SectionList);
}
