public ActionResult PlanDetail(PlanDetailModel model)
{
var id = Request.Params["customerId"].ToString();
TB_PLAN_DETAIL detail = new TB_PLAN_DETAIL();
detail.N_AMOUNT = model.amount;
detail.N_CUSTOMER_ID = int.Parse(id);
detail.N_PLAN_ID = model.planId;
detail.S_DESCRIPTION = model.description;
detail.S_DETAIL = model.detail;
detail.D_EXPRIRE = model.exprireDate;
var modelDB = new CustomerDBModel();
var modelDB2 = new PlanDBModel();
modelDB.createPlanDetail(detail);
var plan = modelDB2.getPlanById(model.planId);
Random rnd = new Random();
int ramdom01 = rnd.Next(10000, 99999);
int ramdom02 = rnd.Next(10000, 99999);
TB_CUSTOMER customer = new TB_CUSTOMER();
customer.N_ID = int.Parse(id);
customer.S_CODE = plan.S_NAME[0].ToString() + ramdom01.ToString() + ramdom02.ToString();
modelDB.updateCodeById(customer);
return(RedirectToAction("List"));
}
public TB_CUSTOMER getCustomerById(int id)
{
object[] sqlParams =
{
new SqlParameter("@N_ID", id)
};
TB_CUSTOMER result = context.Database.SqlQuery <TB_CUSTOMER>("Usp_GetCustomerById @N_ID", sqlParams).SingleOrDefault();
return(result);
}
public object updateCodeById(TB_CUSTOMER model)
{
object[] sqlParams =
{
new SqlParameter("@N_ID", model.N_ID),
new SqlParameter("@S_CODE", model.S_CODE)
};
var result = context.Database.SqlQuery <object>("Usp_updateCodeCustomer @N_ID,@S_CODE", sqlParams).SingleOrDefault();
return(result);
}
public TB_CUSTOMER getCustomer(string account, string password)
{
object[] sqlParams =
{
new SqlParameter("@S_ACCOUNT", account),
new SqlParameter("@S_PASSWORD", password)
};
TB_CUSTOMER accountResult = context.Database.SqlQuery <TB_CUSTOMER>("Usp_GetCustomerLogin @S_ACCOUNT,@S_PASSWORD", sqlParams).SingleOrDefault();
return(accountResult);
}
public object updateCustomerById(TB_CUSTOMER model)
{
object[] sqlParams =
{
new SqlParameter("@N_ID", model.N_ID),
new SqlParameter("@S_CUSTOMER_NAME", model.S_ADDRESS),
new SqlParameter("@S_PHONE", model.S_PHONE),
new SqlParameter("@S_ADDRESS", model.S_ADDRESS),
new SqlParameter("@S_DESCRIPTION", model.S_DESCRIPTION)
};
var result = context.Database.SqlQuery <object>("Usp_updateCustomerById @N_ID,@S_CUSTOMER_NAME,@S_PHONE,@S_ADDRESS,@S_DESCRIPTION", sqlParams).SingleOrDefault();
return(result);
}
public object registerCustomer(TB_CUSTOMER model)
{
object[] sqlParams =
{
new SqlParameter("@S_ACCOUNT", model.S_ACCOUNT),
new SqlParameter("@S_PASSWORD", model.S_PASSWORD),
new SqlParameter("@S_NAME", model.S_NAME),
new SqlParameter("@S_PHONE", model.S_PHONE),
new SqlParameter("@S_ADDRESS", model.S_ADDRESS),
new SqlParameter("@S_DESCRIPTION", model.S_DESCRIPTION)
};
var result = context.Database.SqlQuery <object>("Usp_RegisterCustomer @S_ACCOUNT,@S_PASSWORD,@S_NAME,@S_PHONE,@S_ADDRESS,@S_DESCRIPTION", sqlParams).SingleOrDefault();
return(result);
}
public ActionResult Edit(CustomerModel model)
{
try
{
var modelDB = new CustomerDBModel();
TB_CUSTOMER customer = new TB_CUSTOMER();
customer.N_ID = model.id;
customer.S_NAME = model.customerName;
customer.S_PHONE = model.phone;
customer.S_ADDRESS = model.address;
customer.S_DESCRIPTION = model.description;
modelDB.updateCustomerById(customer);
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Register(CustomerModel model)
{
try
{
var modelDB = new CustomerDBModel();
TB_CUSTOMER customer = new TB_CUSTOMER();
customer.S_ACCOUNT = model.account;
customer.S_PASSWORD = model.password;
customer.S_NAME = model.customerName;
customer.S_PHONE = model.phone;
customer.S_ADDRESS = model.address;
customer.S_DESCRIPTION = model.description;
modelDB.registerCustomer(customer);
return(RedirectToAction("Login"));
}
catch
{
return(View());
}
}
