public async Task <IActionResult> Create(bankmasterIndexViewModel model)
{
if (ModelState.IsValid)
{
var objcategory = new bankmaster
{
id = model.id,
bankname = model.bankname,
bankifsccode = model.bankifsccode,
bankbranch = model.bankbranch,
accountno = model.accountno,
accountholdername = model.accountholdername,
isdeleted = false,
isactive = false
};
_unitofWork.bankmaster.Add(objcategory);
_unitofWork.Save();
TempData["success"] = "Record Save successfully";
return(RedirectToAction(nameof(Index)));
}
else
{
return(View());
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
bankmaster objbank = new bankmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objbank.bankmaster_SRNO = -1;
objbank.bankmaster_LEDGERID = -1;
objbank.bankmaster_ACCOUNTNAME=txtaccountname.Text.Trim().ToString();
objbank.bankmaster_ACCOUNTNO = txtactno.Text.Trim().ToString();
objbank.bankmaster_CITYNAME=ddlcity.SelectedItem.Text;
objbank.bankmaster_STATENAME=ddlstate.SelectedItem.Text;
objbank.bankmaster_BANKBRANCHNAME = txtbranchname.Text.Trim().ToString();
objbank.bankmaster_BANKNAME = ddlbank.SelectedItem.Text;
objbank.bankmaster_MICRCODE = txtmicrcode.Text.Trim().ToString();
objbank.bankmaster_IFSCCODE = txtifsccode.Text.Trim().ToString();
objbank.bankmaster_ADDRESS = txtaddress.Text.Trim().ToString();
objbank.bankmaster_BRANCHID = General.Parse<int>(Session["cmpid"].ToString());
objbank.bankmaster_STATUS=0;
if (objbank.Insert(true, "bankmaster"))
{
string sqlmax = "SELECT MAX(SRNO) AS SRNO FROM BANKMASTER BM WHERE STATUS=0 AND ACCOUNTNAME='" + txtaccountname.Text.Trim().ToString()+"'";
Handler hdnmax = new Handler();
DataTable dtmax = hdnmax.GetTable(sqlmax);
string sqlrel = "SELECT RELATIONSHIPID FROM PERSONALTABLE PT WHERE PT.FIRSTNAME='BANK ACCOUNT' AND BRANCHID=" + Session["branchid"].ToString();
Handler hdnrel = new Handler();
DataTable dtrel = hdnrel.GetTable(sqlrel);
if (dtrel.Rows.Count > 0)
{
Handler hdngroup = new Handler();
DataTable dtgroup = hdngroup.GetTable("SELECT GROUPID FROM ACCOUNTGROUP AG WHERE GROUPNAME='BANK ACCOUNT' AND BRANCHID=0");
personalrelation objpersonalrelation = new personalrelation(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objpersonalrelation.personalrelation_SRNO = -1;
objpersonalrelation.personalrelation_RELATIONSHIPID = General.Parse<int>(dtrel.Rows[0]["RELATIONSHIPID"].ToString());
objpersonalrelation.personalrelation_ASSOSIATEDBRANCH = General.Parse<int>(Session["branchid"].ToString());
objpersonalrelation.personalrelation_ASSOSIATEDFEILD = ddlbank.SelectedItem.Text;
objpersonalrelation.personalrelation_GROUPID = General.Parse<int>(dtgroup.Rows[0]["GROUPID"].ToString());
objpersonalrelation.personalrelation_STATUS = 0;
if (objpersonalrelation.Insert(true, "personalrelation"))
{
Handler hdnledger = new Handler();
string sqlban="SELECT MAX(PR.SRNO) AS LEDGERID FROM PERSONALRELATION PR WHERE PR.GROUPID=" + dtgroup.Rows[0]["GROUPID"].ToString().Trim() + " AND PR.ASSOSIATEDFEILD='" + ddlbank.SelectedItem.Text.Trim() + "' AND PR.RELATIONSHIPID=" + dtrel.Rows[0]["RELATIONSHIPID"].ToString().Trim();
DataTable dtledger = hdnledger.GetTable(sqlban);
bankmaster objbank1 = new bankmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objbank1.bankmaster_SRNO = -1;
objbank1.bankmaster_LEDGERID = General.Parse<int>(dtledger.Rows[0]["LEDGERID"].ToString());
objbank1.bankmaster_BRANCHID = -1;
objbank1.bankmaster_STATUS = -1;
string condition = "BRANCHID=" + Session["branchid"].ToString() + " AND BANKNAME='" + ddlbank.SelectedItem.Text.Trim() + "' AND ACCOUNTNO='" + txtactno.Text.Trim().ToString()+"'";
if (objbank1.Insert(false, "bankmaster", condition))
{
}
}
}
//MessageBox("Bank Created Successfully");
//Response.Redirect("bankaccountdetails.aspx?ID=1&BANKID=" + dtmax.Rows[0][0].ToString().Trim());
Response.Redirect("bankaccountlist.aspx?ID=1");
}
}
public void BindBank(Int64 BankId)
{
bankmaster objbankmaster = (new Cls_bankmaster_b().SelectById(BankId));
if (objbankmaster != null)
{
txtBankName.Text = objbankmaster.bankname;
txtIFSC.Text = objbankmaster.bankifsccode;
txtBankBranch.Text = objbankmaster.bankbranch;
txtAccountNo.Text = objbankmaster.accountno;
txtAccountHolderName.Text = objbankmaster.accountholdername;
}
}
public bankmaster SelectById(Int64 bankid)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
bankmaster objbankmaster = new bankmaster();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "bankmaster_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@bankid", bankid);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objbankmaster.bankid = Convert.ToInt32(ds.Tables[0].Rows[0]["bankid"]);
objbankmaster.bankname = Convert.ToString(ds.Tables[0].Rows[0]["bankname"]);
objbankmaster.bankifsccode = Convert.ToString(ds.Tables[0].Rows[0]["bankifsccode"]);
objbankmaster.bankbranch = Convert.ToString(ds.Tables[0].Rows[0]["bankbranch"]);
objbankmaster.accountno = Convert.ToString(ds.Tables[0].Rows[0]["accountno"]);
objbankmaster.accountholdername = Convert.ToString(ds.Tables[0].Rows[0]["accountholdername"]);
objbankmaster.balance = Convert.ToDecimal(ds.Tables[0].Rows[0]["balance"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objbankmaster);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
bankmaster objbankmaster = new bankmaster();
objbankmaster.bankname = txtBankName.Text.Trim();
objbankmaster.bankifsccode = txtIFSC.Text.Trim();
objbankmaster.bankbranch = txtBankBranch.Text.Trim();
objbankmaster.accountno = txtAccountNo.Text.Trim();
objbankmaster.accountholdername = txtAccountHolderName.Text.Trim();
objbankmaster.balance = Convert.ToDecimal(txtbalance.Text.Trim());
if (Request.QueryString["id"] != null)
{
objbankmaster.bankid = Convert.ToInt32(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_bankmaster_b().Update(objbankmaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/managebank.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Bank Not Updated";
BindBank(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_bankmaster_b().Insert(objbankmaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/managebank.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Bank Not Inserted";
}
}
}
public Int64 Update(bankmaster objbankmaster)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "bankmaster_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@bankid";
param.Value = objbankmaster.bankid;
param.SqlDbType = SqlDbType.Int;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@bankname", objbankmaster.bankname);
cmd.Parameters.AddWithValue("@bankifsccode", objbankmaster.bankifsccode);
cmd.Parameters.AddWithValue("@bankbranch", objbankmaster.bankbranch);
cmd.Parameters.AddWithValue("@accountno", objbankmaster.accountno);
cmd.Parameters.AddWithValue("@accountholdername", objbankmaster.accountholdername);
cmd.Parameters.AddWithValue("@balance", objbankmaster.balance);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
bankmaster objbank = new bankmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objbank.bankmaster_SRNO = -1;
objbank.bankmaster_LEDGERID = -1;
objbank.bankmaster_ACCOUNTNAME = txtaccountname.Text.Trim().ToString();
objbank.bankmaster_ACCOUNTNO = txtactno.Text.Trim().ToString();
objbank.bankmaster_CITYNAME = ddlcity.SelectedItem.Text;
objbank.bankmaster_STATENAME = ddlstate.SelectedItem.Text;
objbank.bankmaster_BANKBRANCHNAME = txtbranchname.Text.Trim().ToString();
objbank.bankmaster_BANKNAME = ddlbank.SelectedItem.Text;
objbank.bankmaster_MICRCODE = txtmicrcode.Text.Trim().ToString();
objbank.bankmaster_IFSCCODE = txtifsccode.Text.Trim().ToString();
objbank.bankmaster_ADDRESS = txtaddress.Text.Trim().ToString();
objbank.bankmaster_BRANCHID = General.Parse<int>(Session["cmpid"].ToString());
objbank.bankmaster_STATUS = General.Parse<int>(ddlstatus.SelectedValue.Trim().ToString());
string condition = "SRNO=" + ViewState["BANKID"].ToString().Trim();
if (objbank.Insert(false, "bankmaster", condition))
{
Response.Redirect("bankaccountlist.aspx?ID=2");
}
}