public ActionResult cdelete(customerdetails_team m)
{
customerdetails_team d = new customerdetails_team();
DB05TMS155_1718Entities1 mn = new DB05TMS155_1718Entities1();
d = mn.customerdetails_team.Find(Convert.ToInt32(TempData["cid"]));
TempData["cnid"] = d.CustomerId;
return(View(d));
}
//view
public ActionResult viewall(customerdetails_team c)
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
List <customerdetails_team> s1 = new List <customerdetails_team>();
s1 = db.customerdetails_team.ToList();
db.SaveChanges();
return(View(s1));
}
public ActionResult updatecus(customerdetails_team q)
{
customerdetails_team c = new customerdetails_team();
DB05TMS155_1718Entities1 mn = new DB05TMS155_1718Entities1();
c = mn.customerdetails_team.Find(Convert.ToInt32(TempData["cid"]));
TempData["cnid"] = c.CustomerId;
return(View(c));
}
public ActionResult updatecus(customerdetails_team q, FormCollection n)
{
try
{
DB05TMS155_1718Entities1 z = new DB05TMS155_1718Entities1();
customerdetails_team a = z.customerdetails_team.Find(Convert.ToInt32(TempData["cnid"]));
string s1 = n["newcname"];
string s2 = n["newaddress1"];
string s3 = n["newaddress2"];
string s4 = n["newage"];
if (s1.Length == 0)
{
n["newcname"] = a.CustomerName;
}
if (s2.Length == 0)
{
n["newaddress1"] = a.AddressLine1;
}
if (s3.Length == 0)
{
n["newaddress2"] = a.AddressLine2;
}
if (s4.Length == 0)
{
n["newage"] = a.CustomerAge.ToString();
}
if (a.stats == "inactive")
{
TempData["AlertMessage"] = 23;
return(RedirectToAction("viewall"));
}
else
{
string a1 = n["newcname"];
string a2 = n["newaddress1"];
string a3 = n["newaddress2"];
int a4 = Convert.ToInt32(n["newage"]);
z.team5ud(Convert.ToInt32(TempData["cnid"]), a1, a4, a2, a3);
TempData["AlertMessage"] = 24;
return(RedirectToAction("viewall"));
}
}
catch (Exception)
{
TempData["alert"] = 15;
return(RedirectToAction("update1"));
}
}
public ActionResult delete(FormCollection n, customerdetails_team a)
{
customerdetails_team t = db.customerdetails_team.Where(x => x.CustomerId == a.CustomerId).FirstOrDefault();
if (t == null)
{
Response.Write("<script>alert('Invalid Customer_ID Id')</script>)");
return(View());
}
else
{
TempData["cid"] = t.CustomerId;
return(RedirectToAction("cdelete", new { id = 0 }));
}
}
public ActionResult viewall(FormCollection F)
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
string searchby = F["search by"];
string searchvalue = F["SearchValue"];
int search = Convert.ToInt32(searchvalue);
customerdetails_team tem = db.customerdetails_team.Find(search);
if (searchby == "CustomerId" || searchby == "CustomerSSNId")
{
if (tem != null)
{
if (searchby == "CustomerId")
{
List <customerdetails_team> templist = db.customerdetails_team.Where(x => x.CustomerId == search).ToList();
return(View("viewall", templist));
}
else
{
List <customerdetails_team> templist = db.customerdetails_team.Where(x => x.CustomerSSNId == (search)).ToList();
return(View("viewall", templist));
}
}
else
{
Response.Write("<script>alert('Please enter valid customerid')</script>");
List <customerdetails_team> s1 = new List <customerdetails_team>();
s1 = db.customerdetails_team.ToList();
db.SaveChanges();
return(View(s1));
}
}
else
{
Response.Write("<script>alert('Choose search by radio button')</script>");
List <customerdetails_team> s1 = new List <customerdetails_team>();
s1 = db.customerdetails_team.ToList();
db.SaveChanges();
return(View(s1));
}
}
public ActionResult cdelete(customerdetails_team n, FormCollection a)
{
DB05TMS155_1718Entities1 z = new DB05TMS155_1718Entities1();
customerdetails_team s = z.customerdetails_team.Find(Convert.ToInt32(TempData["cnid"]));
if (s.stats == "inactive")
{
TempData["AlertMessage"] = 23;
return(RedirectToAction("viewall"));
}
else
{
z.team5delete(Convert.ToInt32(TempData["cnid"]));
TempData["AlertMessage"] = 30;
return(RedirectToAction("viewstatus"));
}
}
public ActionResult Register(customerdetails_team c)
{
customerdetails_team id1 = db.customerdetails_team.Find(c.CustomerSSNId);
if (ModelState.IsValid)
{
if (id1 == null)
{
ObjectParameter o = new ObjectParameter("id", 0);
db.custreg(o, c.CustomerSSNId, c.CustomerName, c.CustomerAge, c.AddressLine1, c.AddressLine2, c.State, c.city);
if (Convert.ToInt64(o.Value) == 0)
{
Response.Write("<script>alert('Customer creation failed')</script>");
}
else
{
Response.Write("<script>alert('Customer creation initiated successfully')</script>");
}
db.SaveChanges();
ModelState.Clear();
int id = Convert.ToInt32(db.getstateid(c.State));
TempData["stateid"] = id;
}
else
{
Response.Write("<script>alert('Already existing Customer ssn id')</script>");
}
}
bind();
// List<SelectListItem> dropdown = new List<SelectListItem>();
return(View("Register"));
}
