public ActionResult ExporttoExcel()
{
var customerdata = ManageCustomerService.CustomerDetails(0, "");
List <ExportManageUserModel> ExportManageUserModel = new List <Models.ExportManageUserModel>();
foreach (var item in customerdata)
{
var model = new ExportManageUserModel();
model.CustomerNo = item.CustomerId;
model.CustomerName = item.FirstName + item.LastName;
model.Email = item.Email;
model.DateofRegistration = item.Date_of_Registration;
model.AvailableCredits = item.Availablecredits;
model.NoOfEvents = item.No_of_events;
ExportManageUserModel.Add(model);
}
GridView gv = new GridView();
gv.DataSource = ExportManageUserModel;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=ManageUser.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int CustomerId = 0)
{
if (Session["CustomerId"] == null)
{
return(RedirectToAction("Login", "Home"));
}
Customer customer = ManageCustomerService.GetCustomerById(CustomerId);
if (customer == null)
{
return(HttpNotFound());
}
CustomerModel model = new CustomerModel();
model.CustomerId = customer.CustomerId;
model.FirstName = customer.FirstName;
model.LastName = customer.LastName;
model.Email = customer.Email;
model.Contactno = customer.Contactno;
model.Username = customer.Username;
model.Password = customer.Password;
model.CompanyName = customer.CompanyName;
model.Date_of_Registration = customer.Date_of_Registration;
model.IsActive = customer.IsActive;
model.AccountStatus = customer.IsActive;
ViewBag.CustomerId = model.CustomerId;
return(View(model));
}
public ActionResult Edit(CustomerModel model)
{
if (Session["CustomerId"] == null)
{
return(RedirectToAction("Login", "Home"));
}
Customer customer = ManageCustomerService.GetCustomerById(model.CustomerId);
customer.FirstName = model.FirstName;
customer.LastName = model.LastName;
customer.Email = model.Email;
customer.Contactno = model.Contactno;
customer.Username = model.Username;
customer.Password = model.Password;
customer.CompanyName = model.CompanyName;
customer.Date_of_Registration = model.Date_of_Registration;
customer.CustomerId = model.CustomerId;
customer.IsActive = model.AccountStatus;
//customer.createddate = DateTime.Now;
//customer.updateddate = DateTime.Now;
ManageCustomerService.UpdateCustomer(customer);
ViewBag.StatusMessage = "SuccessUpdate";
return(View(model));
}
private IEnumerable GetData(int SearchRecords, string SearchTitle, string Alpha)
{
SearchTitle = SearchTitle.Trim().ToLower();
Alpha = Alpha.Trim().ToLower();
List <CustomerModel> Customerlist = new List <CustomerModel>();
var customerdata = ManageCustomerService.CustomerDetails(0, Alpha);
foreach (var data in customerdata)
{
CustomerModel model = new CustomerModel();
model.CustomerId = data.CustomerId;
model.FirstName = data.FirstName;
model.LastName = data.LastName;
model.Email = data.Email;
model.Contactno = data.Contactno;
model.Username = data.Username;
model.Password = data.Password;
model.CompanyName = data.CompanyName;
model.Date_of_Registration = data.Date_of_Registration;
model.NoOfEvents = data.No_of_events.Value;
model.AvailableCredits = data.Availablecredits.Value;
Customerlist.Add(model);
}
return(Customerlist);
}
public ActionResult ExporttoExcel()
{
var customerdata = ManageCustomerService.ManageEvents(0, Convert.ToString(TempData["SearchTitle"]));
List <ManageEventModel> ManageEventModel = new List <Models.ManageEventModel>();
foreach (var item in customerdata)
{
var model = new ManageEventModel();
model.CustomerName = item.Name;
model.EventName = item.EventName;
model.EventStartDate = item.EventStartDate;
model.EventEndDate = item.EventEndDate;
model.RegisteredUser = item.TotalCount;
model.ReferredUser = item.ReferredUsers;
ManageEventModel.Add(model);
}
GridView gv = new GridView();
gv.DataSource = ManageEventModel;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=ManageEvent.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Index"));
}
public ActionResult Delete(int CustomerId)
{
if (Session["CustomerId"] == null)
{
return(RedirectToAction("Login", "Home"));
}
ManageCustomerService.DeleteCustomer(CustomerId);
return(RedirectToAction("Grid"));
}
//Control Customer Panel-------------------------------------------------------------------------------------------
private void btn_search_customer_Click(object sender, EventArgs e)
{
Customer customer = new ManageCustomerService().FindByPhone(search_customer.Text);
if (customer != null)
{
select_customer.Text = customer.CustomerId + " - " + customer.CustomerFullname;
customerPresent = customer;
LoadDeliveryAddress(customer.CustomerId);
}
else
{
MessageBox.Show("Not Found!");
select_customer.Text = null;
customerPresent = null;
LoadDeliveryAddress(-1);
}
}
public ActionResult ChangePassword(int CustomerId, string Password)
{
var rsult = "";
try
{
Customer customer = ManageCustomerService.GetCustomerById(CustomerId);
customer.Password = Password;
ManageCustomerService.UpdateCustomer(customer);
rsult = "Password Saved Successfully";
}
catch
{
rsult = "Try again";
}
return(Json(rsult));
}
private IEnumerable GetData(int SearchRecords, string SearchTitle, string Alpha)
{
SearchTitle = SearchTitle.Trim().ToLower();
Alpha = Alpha.Trim().ToLower();
List <ManageEventModel> Customerlist = new List <ManageEventModel>();
var customerdata = ManageCustomerService.ManageEvents(0, SearchTitle);
foreach (var data in customerdata)
{
ManageEventModel model = new ManageEventModel();
model.CustomerName = data.Name;
model.EventName = data.EventName;
model.EventStartDate = data.EventStartDate;
model.EventEndDate = data.EventEndDate;
model.RegisteredUser = data.TotalCount;
model.ReferredUser = data.ReferredUsers;
Customerlist.Add(model);
}
return(Customerlist);
}
public ActionResult Create(CustomerModel model)
{
if (Session["CustomerId"] == null)
{
return(RedirectToAction("Login", "Home"));
}
if (ModelState.IsValid)
{
var matchuser = db.Customers.Where(a => a.Username.Equals(model.Username)).FirstOrDefault();
if (matchuser == null)
{
Customer customer = new Customer();
customer.CustomerId = model.CustomerId;
customer.FirstName = model.FirstName;
customer.LastName = model.LastName;
customer.Email = model.Email;
customer.Contactno = model.Contactno;
customer.Username = model.Username;
customer.Password = model.Password;
customer.CompanyName = model.CompanyName;
customer.Date_of_Registration = DateTime.Now;
customer.IsActive = true;
customer.createddate = DateTime.Now;
customer.updateddate = DateTime.Now;
ViewBag.CustomerId = customer.CustomerId;
ViewBag.StatusMessage = "SuccessAdd";
var role = RoleService.GetRoleByName("User");
CustomerRole customerrole = new CustomerRole();
if (role != null)
{
customerrole.RoleId = role.RoleId;
customerrole.CustomerId = customer.CustomerId;
}
customer.CustomerRoles.Add(customerrole);
ManageCustomerService.InsertCustomer(customer);
//Transaction
Transaction transaction = new Transaction();
transaction.CustomerId = customer.CustomerId;
transaction.Amount = 100;
transaction.TransactionDate = DateTime.Now;
transaction.Status = "completed";
transaction.TransactionType = "credit";
transaction.CreatedDate = DateTime.Now;
transaction.UpdatedDate = DateTime.Now;
transaction.PaymentMethod = "offline";
TransactionService.InsertTransaction(transaction);
}
else
{
ViewBag.Message = " This user is already exists";
return(View());
}
}
return(View(model));
}