public void SaveDetails()
{
PlanMaster objPlan = new PlanMaster();
objPlan.PlanId = Convert.ToInt32(txtPlanID.Text);
objPlan.PlanName = txtPlanName.Text;
objPlan.DateOfCreation = dtpDateOfCreation.Value.Date.ToString("yyyy-MM-dd");
objPlan.Limit = Convert.ToInt32(txtLimit.Text);
objPlan.BookOnHold = Convert.ToInt32(txtBookOnHold.Text);
objPlan.Validity = dtpDateOfValidity.Value.Date.ToString("yyyy-MM-dd");
objPlan.Amount = Convert.ToDouble(txtAmount.Text);
objPlan.Discount = Convert.ToDouble(txtDiscount.Text);
objPlan.Status = cmbStatus.SelectedIndex;
PlanMasterBL p = new PlanMasterBL();
int n = p.SavePlanMasterdata(objPlan);
if (n > 0)
{
MessageBox.Show("Record is Saved", "Message", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Record is Not Saved", "Message", MessageBoxButtons.OK);
}
}
public int DeletePlanDetails()
{
int n = 0;
try
{
PlanMaster p = new PlanMaster();
p.PlanId = Convert.ToInt32(txtPlanID.Text);
PlanMasterBL bl = new PlanMasterBL();
n = bl.DeletePlanMasterdata(p);
MessageBox.Show("Records are Deleted...");
}
catch (Exception ex)
{
MessageBox.Show("Records are not Deleted...Please Try Again");
}
finally
{
}
return(n);
}
public int DeletePlanMasterdataFromDB(PlanMaster p)
{
int n = 0;
SqlConnection connectn = null;
string con = "Data Source=AJAY;Initial Catalog=LMS;Integrated Security=True";
try
{
connectn = new SqlConnection(con);
SqlCommand cmd = new SqlCommand("spDeletePlanMasterDetails", connectn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Plan_Id", p.PlanId);
connectn.Open();
n = cmd.ExecuteNonQuery();
n = n > 0 ? 1 : 0;
}
catch (Exception ex)
{
}
finally
{
connectn.Close();
}
return(n);
}
public ActionResult DeleteConfirmed(int id)
{
PlanMaster planMaster = db.PlanMasters.Find(id);
db.PlanMasters.Remove(planMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool UpdatePlanMaster(PlanMaster planMaster)
{
_context.Entry(planMaster).Property(x => x.RecStatus).IsModified = true;
_context.Entry(planMaster).Property(x => x.PlanAmount).IsModified = true;
_context.Entry(planMaster).Property(x => x.ServiceTax).IsModified = true;
var result = _context.SaveChanges();
return(result > 0);
}
public void Delete(PlanMaster delObj)
{
using (var session = GetSession())
{
using (var trans = session.BeginTransaction())
{
session.Delete(delObj);
trans.Commit();
}
}
}
public void Delete(PlanMaster delObj)
{
using (var session = GetSession())
{
using (var trans = session.BeginTransaction())
{
session.Delete(delObj);
trans.Commit();
}
}
}
public ActionResult Edit(PlanMaster planMaster)
{
if (ModelState.IsValid)
{
planMaster.Isactive = true;
planMaster.ModifiedOn = DateTime.Now;
db.Entry(planMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(planMaster));
}
public ActionResult Create(PlanMaster planMaster)
{
if (ModelState.IsValid)
{
planMaster.Isactive = true;
planMaster.CreatedOn = DateTime.Now;
db.PlanMasters.Add(planMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(planMaster));
}
// GET: PlanMasters/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PlanMaster planMaster = db.PlanMasters.Find(id);
if (planMaster == null)
{
return(HttpNotFound());
}
return(View(planMaster));
}
public void Save(PlanMaster saveObj)
{
using (var session = GetSession())
{
using (var trans = session.BeginTransaction())
{
session.FlushMode = FlushMode.Commit;
session.SaveOrUpdate(saveObj);
trans.Commit();
session.Flush();
//}
}
}
}
public void Save(PlanMaster saveObj)
{
using (var session = GetSession())
{
using (var trans = session.BeginTransaction())
{
session.FlushMode = FlushMode.Commit;
session.SaveOrUpdate(saveObj);
trans.Commit();
session.Flush();
//}
}
}
}
public void InsertPlan(PlanMaster plan)
{
using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection")))
{
var paramater = new DynamicParameters();
paramater.Add("@PlanID", plan.PlanID);
paramater.Add("@SchemeID", plan.SchemeID);
paramater.Add("@PeriodID", plan.PeriodID);
paramater.Add("@PlanName", plan.PlanName);
paramater.Add("@PlanAmount", plan.PlanAmount);
paramater.Add("@ServiceTax", plan.ServiceTax);
paramater.Add("@CreateUserID", plan.CreateUserID);
paramater.Add("@ModifyUserID", plan.ModifyUserID);
paramater.Add("@RecStatus", plan.RecStatus);
var value = con.Query <int>("sprocPlanMasterInsertUpdateSingleItem", paramater, null, true, 0, commandType: CommandType.StoredProcedure);
}
}
public int DeletePlanMasterdata(PlanMaster objPlan)
{
int n = 0;
try
{
IPlanMasterDA p = new PlanMasterDA();
n = Convert.ToInt32(p.DeletePlanMasterdataFromDB(objPlan));
}
catch (Exception ex)
{
}
return(n);
}
public void UpdatePlanDetails()
{
try
{
PlanMaster p = new PlanMaster();
p.PlanId = Convert.ToInt32(txtPlanID.Text);
p.PlanName = txtPlanName.Text;
p.DateOfCreation = dtpDateOfCreation.Value.Date.ToString("yyyy-MM-dd");
p.Limit = Convert.ToInt32(txtLimit.Text);
p.BookOnHold = Convert.ToInt32(txtBookOnHold.Text);
p.Validity = dtpDateOfValidity.Value.Date.ToString("yyyy-MM-dd");
p.Amount = Convert.ToInt32(txtAmount.Text);
p.Discount = Convert.ToInt32(txtDiscount.Text);
if (cmbStatus.SelectedItem == "Active")
{
p.Status = 0;
}
else
{
p.Status = 1;
}
PlanMasterBL bl = new PlanMasterBL();
int n = bl.UpdatePlanMasterdata(p);
MessageBox.Show("Record is Updated...");
}
catch (Exception ex)
{
MessageBox.Show("Records are not Saved...Please Try Again");
}
finally
{
//DisableControls(this);
}
}
public int UpdatePlanMasterdataToDB(PlanMaster objPlan)
{
int n = 0;
SqlConnection connectn = null;
string con = "Data Source=AJAY;Initial Catalog=LMS;Integrated Security=True";
try
{
connectn = new SqlConnection(con);
SqlCommand cmd = new SqlCommand("spUpdatePlanMasterDetails", connectn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Plan_Id", objPlan.PlanId);
cmd.Parameters.AddWithValue("@Plan_Name", objPlan.PlanName);
cmd.Parameters.AddWithValue("@Plan_Doc", objPlan.DateOfCreation);
cmd.Parameters.AddWithValue("@Plan_Book_Limit", objPlan.Limit);
cmd.Parameters.AddWithValue("@Plan_Book_Can_Hold", objPlan.BookOnHold);
cmd.Parameters.AddWithValue("@Plan_Validity", objPlan.Validity);
cmd.Parameters.AddWithValue("@Plan_Amount", objPlan.Amount);
cmd.Parameters.AddWithValue("@Plan_Discount", objPlan.Discount);
cmd.Parameters.AddWithValue("@Plan_Status", objPlan.Status);
connectn.Open();
n = cmd.ExecuteNonQuery();
n = n > 0 ? 1 : 0;
}
catch (Exception ex)
{
}
finally
{
connectn.Close();
}
return(n);
}
public ActionResult PlanDetails(int id)
{
PlanMaster plan = db.PlanMasters.FirstOrDefault(x => x.Id == id && x.Isactive == true);
return(View(plan));
}
