public string AutoGenerateId(Models.AutoGenerate objModelAuto)
{
con.Open();
string query = "select " + objModelAuto.ColumnName + " from " + objModelAuto.TableName + " where id in (select max(id) from " +
objModelAuto.TableName + ")";
SqlCommand cmd = new SqlCommand(query, con);
try
{
string s = cmd.ExecuteScalar().ToString();
string[] s1 = s.Split('_');
int i = int.Parse(s1[1]);
i++;
string x = s1[0] + "_" + i;
con.Close();
return(x);
}
catch (Exception ex)
{
return(objModelAuto.ColumnName + "_1");//ex.Message;
}
// return " ";
}
public ActionResult Create(Models.Department objModelDepartment)
{
try
{
// TODO: Add insert logic here
int i = objDalDept.AddDept(objModelDepartment);
if (i == 1)
{
Models.AutoGenerate objModelAutoGenerate = new Models.AutoGenerate();
objModelAutoGenerate.TableName = "dept";
objModelAutoGenerate.ColumnName = "dno";
objModelDepartment.Dno = objServiceAuto.AutoGenerateId(objModelAutoGenerate);
ViewBag.message = "Department added";
return(View(objModelDepartment));
}
return(View());
// return RedirectToAction("Index");
}
catch (Exception ex)
{
ViewBag.message = ex.Message;
return(View());
// return View();
}
}
public ActionResult Create()
{
Models.AutoGenerate objModelAuto = new Models.AutoGenerate();
Models.Department objModelDepartment = new Department();
objModelAuto.TableName = "dept";
objModelAuto.ColumnName = "dno";
objModelDepartment.Dno = objServiceAuto.AutoGenerateId(objModelAuto);
return(View(objModelDepartment));
}
// GET: Technology/Create
public ActionResult Create()
{
Models.AutoGenerate objmodauto = new Models.AutoGenerate();
Models.Technology objmodtech = new Models.Technology();
objmodauto.TableName = "technology";
objmodauto.ColumnName = "techid";
objmodtech.techid = objservices.AutoGenerateId(objmodauto);
return(View(objmodtech));
}
public ActionResult Create(Models.Technology objmodtech)
{
Models.AutoGenerate objmodauto = new Models.AutoGenerate();
// Models.Technology objmodtech = new Models.Technology();
int i = objdaltech.AddTechnology(objmodtech);
objmodauto.TableName = "technology";
objmodauto.ColumnName = "techid";
objmodtech.techid = objservices.AutoGenerateId(objmodauto);
return(RedirectToAction("Create"));//View(objmodtech);
}
