public ActionResult Gird()
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
ViewBag.Client = db.spGetClientMaster(null).ToList();
return(View());
}
}
public static TermModel getTermById(int?id)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.TERM_MASTER.Where(x => x.TERM_ID == id).FirstOrDefault();
return(new TermModel {
TERM_ID = query.TERM_ID,
TERM_NAME = query.TERM_NAME
});
}
}
public static ModeModel getModeById(int?id)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.MODE_MASTER.Where(x => x.MODE_ID == id).FirstOrDefault();
return(new ModeModel
{
MODE_ID = query.MODE_ID,
MODE_NAME = query.MODE_NAME
});
}
}
public static CountryModel getCountryById(int?id)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.COUNTRY_MASTER.Where(x => x.COUNTRY_ID == id).FirstOrDefault();
return(new CountryModel
{
COUNTRY_ID = query.COUNTRY_ID,
COUNTRY_NAME = query.COUNTRY_NAME
});
}
}
public static PlanModel getPlanById(int?id)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.PLAN_MASTER.Where(x => x.PLAN_ID == id).FirstOrDefault();
return(new PlanModel {
PLAN_ID = query.PLAN_ID,
PLAN_CODE = query.PLAN_CODE,
PLAN_NAME = query.PLAN_NAME
});
}
}
public static StateModel getStateById(int?id)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.STATE_MASTER.Where(x => x.STATE_ID == id).FirstOrDefault();
return(new StateModel
{
STATE_ID = query.STATE_ID,
STATE_NAME = query.STATE_NAME,
COUNTRY_ID = Convert.ToInt32(query.COUNTRY_ID)
});
}
}
public static bool updateMode(ModeModel model)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.MODE_MASTER.Where(x => x.MODE_ID == model.MODE_ID).FirstOrDefault();
query.MODE_NAME = model.MODE_NAME;
query.UPDATED_BY = SessionWrapper.UserId;
query.UPDATED_ON = DateTime.Now;
db.SaveChanges();
return(true);
}
}
public static bool insertTerm(TermModel model)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
db.TERM_MASTER.Add(new TERM_MASTER {
TERM_NAME = model.TERM_NAME,
IS_ACTIVE = 1,
CREATED_BY = SessionWrapper.UserId,
CREATED_ON = DateTime.Now
});
db.SaveChanges();
return(true);
}
}
public static CityModel getCityById(int?id)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.CITY_MASTER.Where(x => x.CITY_ID == id).FirstOrDefault();
var country = db.STATE_MASTER.Where(x => x.STATE_ID == query.STATE_ID).FirstOrDefault();
return(new CityModel
{
CITY_ID = query.CITY_ID,
CITY_NAME = query.CITY_NAME,
STATE_ID = Convert.ToInt32(query.STATE_ID),
COUNTRY_ID = Convert.ToInt32(country.COUNTRY_ID)
});
}
}
public static string getStateNameById(int id)
{
if (id != null && id != 0)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var result = db.STATE_MASTER.Where(x => x.STATE_ID == id).FirstOrDefault();
return(result.STATE_NAME);
}
}
else
{
return("");
}
}
public static bool updateUser(UserModel model)
{
string password = System.Web.Helpers.Crypto.HashPassword(model.PASSWORD);
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var search = db.USER_MASTER.Where(x => x.USER_ID_ == model.USER_ID).FirstOrDefault();
search.USER_NAME = model.USER_NAME;
search.PASSWORD = password;
search.UPDATED_BY = Convert.ToInt32(HttpContext.Current.Session["UserId"].ToString());
search.UPDATED_ON = DateTime.Now;
db.SaveChanges();
return(true);
}
}
public static bool insertPlan(PlanModel model)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
db.PLAN_MASTER.Add(new PLAN_MASTER {
PLAN_CODE = model.PLAN_CODE,
PLAN_NAME = model.PLAN_NAME,
IS_ACTIVE = 1,
CREATED_BY = SessionWrapper.UserId,
CREATED_ON = DateTime.Now
});
db.SaveChanges();
return(true);
}
}
public static List <CountryModel> getCountry()
{
List <CountryModel> list = new List <CountryModel>();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
foreach (var item in db.COUNTRY_MASTER.ToList())
{
list.Add(new CountryModel {
COUNTRY_ID = item.COUNTRY_ID,
COUNTRY_NAME = item.COUNTRY_NAME
});
}
return(list);
}
}
public static string getCountryNameById(int id)
{
if (id != null && id != 0)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.STATE_MASTER.Where(x => x.STATE_ID == id).FirstOrDefault();
var result = db.COUNTRY_MASTER.Where(x => x.COUNTRY_ID == query.COUNTRY_ID).FirstOrDefault();
return(result.COUNTRY_NAME);
}
}
else
{
return("");
}
}
public static List <SelectListItem> listState()
{
List <SelectListItem> list = new List <SelectListItem>();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
foreach (var item in db.STATE_MASTER.ToList())
{
list.Add(new SelectListItem
{
Text = item.STATE_NAME,
Value = item.STATE_ID.ToString()
});
}
return(list);
}
}
public static bool updateCountry(CountryModel model)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.COUNTRY_MASTER.Where(x => x.COUNTRY_ID == model.COUNTRY_ID).FirstOrDefault();
query.COUNTRY_NAME = model.COUNTRY_NAME;
int valid = db.SaveChanges();
if (valid == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static List <CityModel> getCity()
{
List <CityModel> list = new List <CityModel>();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
foreach (var item in db.CITY_MASTER.ToList())
{
list.Add(new CityModel
{
CITY_ID = item.CITY_ID,
CITY_NAME = item.CITY_NAME,
STATE_ID = Convert.ToInt32(item.STATE_ID)
});
}
return(list);
}
}
public static List <StateModel> getState()
{
List <StateModel> list = new List <StateModel>();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
foreach (var item in db.STATE_MASTER.ToList())
{
list.Add(new StateModel
{
STATE_ID = item.STATE_ID,
STATE_NAME = item.STATE_NAME,
COUNTRY_ID = Convert.ToInt32(item.COUNTRY_ID)
});
}
return(list);
}
}
public static bool insertUser(UserModel model)
{
string password = System.Web.Helpers.Crypto.HashPassword(model.PASSWORD);
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
db.USER_MASTER.Add(new USER_MASTER {
USER_NAME = model.USER_NAME,
PASSWORD = password,
CREATED_ON = DateTime.Now,
CREATED_BY = Convert.ToInt32(HttpContext.Current.Session["UserId"].ToString()),
ROLE_ABBR = "USR",
IS_ACTIVE = 1
});
db.SaveChanges();
return(true);
}
}
public static bool insertCountry(CountryModel model)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
db.COUNTRY_MASTER.Add(new COUNTRY_MASTER
{
COUNTRY_NAME = model.COUNTRY_NAME
});
int valid = db.SaveChanges();
if (valid == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool insertState(StateModel model)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
db.STATE_MASTER.Add(new STATE_MASTER
{
STATE_NAME = model.STATE_NAME,
COUNTRY_ID = model.COUNTRY_ID
});
int valid = db.SaveChanges();
if (valid == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool insertCity(CityModel model)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
db.CITY_MASTER.Add(new CITY_MASTER
{
CITY_NAME = model.CITY_NAME,
STATE_ID = model.STATE_ID
});
int valid = db.SaveChanges();
if (valid == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static UserModel getUserById(int?id)
{
UserModel model = new UserModel();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var search = db.USER_MASTER.Where(x => x.USER_ID_ == id).FirstOrDefault();
if (search != null)
{
model.USER_ID = Convert.ToInt32(search.USER_ID_);
model.USER_NAME = search.USER_NAME;
model.PASSWORD = search.PASSWORD;
return(model);
}
else
{
return(new UserModel());
}
}
}
public static List <TermModel> getAllTerm()
{
List <TermModel> list = new List <TermModel>();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
foreach (var item in db.TERM_MASTER.ToList())
{
list.Add(new TermModel {
TERM_ID = item.TERM_ID,
TERM_NAME = item.TERM_NAME,
IS_ACTIVE = Convert.ToInt32(item.IS_ACTIVE),
UPDATED_BY = Convert.ToInt32(item.UPDATED_BY),
UPDATED_ON = Convert.ToDateTime(item.UPDATED_ON),
CREATED_BY = Convert.ToInt32(item.CREATED_BY),
CREATED_ON = Convert.ToDateTime(item.CREATED_ON)
});
}
return(list);
}
}
public ActionResult Edit(int?id)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var search = db.spGetClientMaster(id).FirstOrDefault();
return(Json(new ClientAssuranceModel
{
CLIENT_ID = search.CLIENT_ID,
FIRST_NAME = search.FIRST_NAME,
MIDDLE_NAME = search.MIDDLE_NAME,
LAST_NAME = search.LAST_NAME,
DOB = Convert.ToDateTime(search.DOB),
MOBILE = search.MOBILE,
EMAIL = search.EMAIL,
HEIGHT = Convert.ToSingle(search.HEIGHT),
WEIGHT = Convert.ToSingle(search.WEIGHT),
DATE_OF_MATURITY = Convert.ToDateTime(search.DATE_OF_MATURITY),
DOS = Convert.ToDateTime(search.DOS),
IDENTITY_OF_BODY = search.IDENTITY_OF_BODY,
NEXT_PREMIUM_DATE = Convert.ToDateTime(search.NEXT_PREMIUM_DATE),
CITY_ID = Convert.ToInt32(search.CITY_ID),
USER_ID = Convert.ToInt32(search.USER_ID),
AGE = Convert.ToInt32(search.AGE),
PIN_CODE = search.PIN_CODE,
AADDRESS = search.ADDRESS,
STATE_ID = Convert.ToInt32(search.STATE_ID),
COUNTRY_ID = Convert.ToInt32(search.COUNTRY_ID),
MODE_ID = Convert.ToInt32(search.MODE_ID),
PLAN_ID = Convert.ToInt32(search.PLAN_ID),
TERM_ID = Convert.ToInt32(search.TERM_ID),
CLIENTASSURANCE_ID = search.CLIENTASSURANCE_ID,
PREMIUM = Convert.ToSingle(search.PREMIUM),
POLICY_NUMBER = search.POLICY_NUMBER,
SUM_OF_ASSURANCE = Convert.ToSingle(search.SUM_OF_ASSURANCE),
NOMINEE = search.NOMINEE
}, JsonRequestBehavior.AllowGet));
}
}
public static List <UserModel> getUserList()
{
List <UserModel> list = new List <UserModel>();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
var query = db.USER_MASTER.OrderByDescending(x => x.USER_ID_).ToList();
foreach (var item in query)
{
list.Add(new UserModel {
USER_ID = Convert.ToInt32(item.USER_ID_),
USER_NAME = item.USER_NAME,
PASSWORD = item.PASSWORD,
CREATED_ON = item.CREATED_ON,
IS_ACTIVE = Convert.ToInt32(item.IS_ACTIVE),
UPDATED_BY = Convert.ToInt32(item.UPDATED_BY),
UPDATED_ON = Convert.ToDateTime(item.UPDATED_ON)
});
}
return(list);
}
}
public static List <PlanModel> getAllPlan()
{
List <PlanModel> list = new List <PlanModel>();
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
foreach (var item in db.PLAN_MASTER.ToList())
{
list.Add(new PlanModel {
PLAN_ID = item.PLAN_ID,
PLAN_CODE = item.PLAN_CODE,
PLAN_NAME = item.PLAN_NAME,
IS_ACTIVE = Convert.ToInt32(item.IS_ACTIVE),
UPDATED_BY = Convert.ToInt32(item.UPDATED_BY),
UPDATED_ON = Convert.ToDateTime(item.UPDATED_ON),
CREATED_BY = Convert.ToInt32(item.CREATED_BY),
CREATED_ON = Convert.ToDateTime(item.CREATED_ON)
});
}
return(list);
}
}
public ActionResult Create(ClientAssuranceModel model)
{
if (ModelState.IsValid)
{
if (model.CLIENT_ID == 0)
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
model.USER_ID = SessionWrapper.UserId;
db.spCreateClientMaster(model.FIRST_NAME, model.LAST_NAME, model.MIDDLE_NAME, model.DOB, model.AGE, model.MOBILE, model.EMAIL, model.DOS, model.WEIGHT, model.HEIGHT, model.IDENTITY_OF_BODY, model.AADDRESS, model.PIN_CODE, model.CITY_ID, model.USER_ID, true, false, model.USER_ID, System.DateTime.Now);
model.CLIENT_ID = db.CLIENT_MASTER.Max(x => x.CLIENT_ID);
db.spCreateClientAssuranceMaster(model.PREMIUM, model.POLICY_NUMBER, model.SUM_OF_ASSURANCE, model.PLAN_ID, model.MODE_ID, model.TERM_ID, model.DATE_OF_MATURITY, System.DateTime.Now, model.NOMINEE, model.CLIENT_ID, true, false, model.USER_ID, System.DateTime.Now);
ModelState.Clear();
return(Json("Save Country successfully.", JsonRequestBehavior.AllowGet));
}
}
else
{
using (LIC_CMSEntities db = new LIC_CMSEntities())
{
db.spUpdateClientMaster(model.CLIENT_ID, model.FIRST_NAME, model.LAST_NAME, model.MIDDLE_NAME, model.DOB, model.AGE, model.MOBILE, model.EMAIL, model.DOS, model.WEIGHT, model.HEIGHT, model.IDENTITY_OF_BODY, model.AADDRESS, model.PIN_CODE, model.CITY_ID, model.USER_ID, true, false, model.USER_ID, System.DateTime.Now);
db.spUpdateClientAssuranceMaster(model.CLIENTASSURANCE_ID, model.PREMIUM, model.POLICY_NUMBER, model.SUM_OF_ASSURANCE, model.PLAN_ID, model.MODE_ID, model.TERM_ID, model.DATE_OF_MATURITY, model.NEXT_PREMIUM_DATE, model.NOMINEE, model.CLIENT_ID, true, false, model.USER_ID, System.DateTime.Now);
ModelState.Clear();
return(Json("Update Country successfully.", JsonRequestBehavior.AllowGet));
}
}
}
else
{
return(Json("Please fill all fields.", JsonRequestBehavior.AllowGet));
}
}
