public bool benDetails(BeneficiaryBal bal)
{
bool status = false;
using (SqlConnection cn = new SqlConnection(ConfigurationManager
.ConnectionStrings["ZigmaCS"].ToString()))
{
try
{
SqlCommand cmd = new SqlCommand("InsertBeneficiary", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@NickName", bal.Nickname);
cmd.Parameters.AddWithValue("@BenId", bal.BeneficiaryId);
cmd.Parameters.AddWithValue("@LoginId", bal.UserId);
cn.Open();
int row = cmd.ExecuteNonQuery();
if (row == -1)
{
status = true;
}
}
catch (Exception ex)
{
status = false;
throw new Exception(ex.Message);
}
return(status);
}
}
public bool ShowBen(BeneficiaryBal bal, out string Nick, out int Bid)
{
bool status = false;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ZigmaCS"].ToString());
try
{
SqlCommand cmd = new SqlCommand("ShowBeneficiary", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
cmd.Parameters.Add("@BenId", SqlDbType.Int);
cmd.Parameters["@BenId"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@NickName", SqlDbType.VarChar, 10);
cmd.Parameters["@NickName"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@LoginId", bal.UserId);
//cmd.Parameters.AddWithValue("@Account_No", bal.AccountNo);
//cmd.Parameters.AddWithValue("@IFSC", bal.IfscCode);
SqlDataReader dr = cmd.ExecuteReader();
Bid = Convert.ToInt32(cmd.Parameters["@BenId"].Value);
Nick = (string)cmd.Parameters["@NickName"].Value;
if (Bid != 0)
{
status = true;
}
else
{
status = false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
cn.Close();
cn.Dispose();
}
return(status);
}
public ActionResult BenAction()
{
BeneficiaryBal bal = new BeneficiaryBal();
bal.UserId = Convert.ToInt32(Session["loginid"]);
BenDal dal = new BenDal();
bool status = dal.ShowBen(bal, out string Nick, out int Bid);
BeneficiaryModel model = new BeneficiaryModel();
if (status)
{
model.BeneficiaryId = Bid;
model.Nickname = Nick;
model.UserId = bal.UserId;
}
return(View(model));
}
public ActionResult AddBen(BeneficiaryModel ben)
{
BeneficiaryBal bal = new BeneficiaryBal();
//Session passing
bal.UserId = Convert.ToInt32(Session["loginid"]);
bal.BeneficiaryId = ben.BeneficiaryId;
bal.Nickname = ben.Nickname;
BenDal dal = new BenDal();
bool status = dal.benDetails(bal);
if (status)
{
return(RedirectToAction("BenAction"));
}
else
{
return(View());
}
}