public ActionResult Create(clientClass Obj_client, string command)
        {
            using (clientCtl db = new clientCtl()){
                if (ModelState.IsValid)
                {
                    db.insert(Obj_client);
                    if (command.ToLower().Trim() == "save")
                    {
                        string sesionval = Convert.ToString(Session["CreatePreviousURL"]);
                        if (!string.IsNullOrEmpty(sesionval))
                        {
                            Session.Remove("CreatePreviousURL");
                            return(Redirect(sesionval));
                        }
                        else
                        {
                            return(RedirectToAction("Index"));
                        }
                    }
                    else
                    {
                        ModelState.Clear();
                        return(View());
                    }
                }

                return(View(Obj_client));
            }
        }
 public ActionResult Edit(Int32 Clientid)
 {
     using (clientCtl db = new clientCtl()){
         clientClass obj_client = db.selectById(Clientid);
         Session["EditPreviousURL"] = Convert.ToString(ControllerContext.HttpContext.Request.UrlReferrer);
         return(View(obj_client));
     }
 }
 public ActionResult Edit(clientClass Obj_client)
 {
     using (clientCtl db = new clientCtl()){
         if (ModelState.IsValid)
         {
             db.update(Obj_client);
             string sesionval = Convert.ToString(Session["EditPreviousURL"]);
             if (!string.IsNullOrEmpty(sesionval))
             {
                 Session.Remove("EditPreviousURL");
                 return(Redirect(sesionval));
             }
             else
             {
                 return(RedirectToAction("Index"));
             }
         }
         return(View(Obj_client));
     }
 }
 public ActionResult Details(Int32 Clientid)
 {
     using (clientCtl db = new clientCtl()){ clientClass obj_client = db.selectById(Clientid);
                                             return(View(obj_client)); }
 }
 public ActionResult SaveRecords(FormCollection model)
 {
     if (ModelState.IsValid)
     {
         using (clientCtl db = new clientCtl()){
             var ClientidArray         = model.GetValues("item.Clientid");
             var ClientnameArray       = model.GetValues("item.Clientname");
             var ClientcodeArray       = model.GetValues("item.Clientcode");
             var ClientshortnameArray  = model.GetValues("item.Clientshortname");
             var Addressline1Array     = model.GetValues("item.Addressline1");
             var Addressline2Array     = model.GetValues("item.Addressline2");
             var LocationcityArray     = model.GetValues("item.Locationcity");
             var StateidArray          = model.GetValues("item.Stateid");
             var LocationzipArray      = model.GetValues("item.Locationzip");
             var BudgetstartmonthArray = model.GetValues("item.Budgetstartmonth");
             for (Int32 i = 0; i < ClientidArray.Length; i++)
             {
                 clientClass obj_update = db.selectById(Convert.ToInt32(ClientidArray[i]));
                 if (!string.IsNullOrEmpty(Convert.ToString(ClientidArray)))
                 {
                     obj_update.Clientid = Convert.ToInt32(ClientidArray[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(ClientnameArray)))
                 {
                     obj_update.Clientname = Convert.ToString(ClientnameArray[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(ClientcodeArray)))
                 {
                     obj_update.Clientcode = Convert.ToString(ClientcodeArray[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(ClientshortnameArray)))
                 {
                     obj_update.Clientshortname = Convert.ToString(ClientshortnameArray[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(Addressline1Array)))
                 {
                     obj_update.Addressline1 = Convert.ToString(Addressline1Array[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(Addressline2Array)))
                 {
                     obj_update.Addressline2 = Convert.ToString(Addressline2Array[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(LocationcityArray)))
                 {
                     obj_update.Locationcity = Convert.ToString(LocationcityArray[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(StateidArray)))
                 {
                     obj_update.Stateid = Convert.ToInt32(StateidArray[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(LocationzipArray)))
                 {
                     obj_update.Locationzip = Convert.ToString(LocationzipArray[i]);
                 }
                 if (!string.IsNullOrEmpty(Convert.ToString(BudgetstartmonthArray)))
                 {
                     obj_update.Budgetstartmonth = Convert.ToInt32(BudgetstartmonthArray[i]);
                 }
                 db.update(obj_update);
             }
         }
     }
     return(RedirectToAction("EditTable"));
 }