public static void Create(FormdetailDataModel formdetail) { MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("Core_CreateFormdetail", connection); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; MySqlParameter paramID = new MySqlParameter("pID", formdetail.ID); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramID); MySqlParameter paramName = new MySqlParameter("pName", formdetail.Name); paramName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramName); MySqlParameter paramFieldType = new MySqlParameter("pFieldType", formdetail.FieldType); paramFieldType.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramFieldType); MySqlParameter paramTableName = new MySqlParameter("pTableName", formdetail.TableName); paramTableName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramTableName); MySqlParameter paramFormID = new MySqlParameter("pFormID", formdetail.FormID); paramFormID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramFormID); DataTable results = new DataTable(); adapter.Fill(results); }
public override void Create(FormdetailDataModel formdetail) { if (HttpContext.Current.Session["formdetailParentID"] != null) { formdetail.FormID = Convert.ToInt32(HttpContext.Current.Session["formdetailParentID"]); } base.Create(formdetail); }
public virtual void Update(FormdetailDataModel formdetail) { if (formdetail.ID > 0) { FormdetailDAL.Update(formdetail); } else { throw new Exception("Page not found"); } }
public ActionResult Create(FormdetailDataModel formdetail) { FormdetailBO.GetInstance().Create(formdetail); if (Session["formdetailParentID"] != null) { return(RedirectToAction("Index", new { id = Convert.ToInt32(Session["formdetailParentID"]) })); } else { return(RedirectToAction("Index")); } }
public static List <FormdetailDataModel> GetByForm(int id) { List <FormdetailDataModel> formdetails = new List <FormdetailDataModel>(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetFormdetailsByForm", connection); MySqlParameter paramID = new MySqlParameter("pID", id); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramID); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; DataTable results = new DataTable(); adapter.Fill(results); foreach (DataRow item in results.Rows) { FormdetailDataModel formdetail = new FormdetailDataModel(); if (item["ID"].GetType() != typeof(DBNull)) { formdetail.ID = Convert.ToInt32(item["ID"]); } if (item["Name"].GetType() != typeof(DBNull)) { formdetail.Name = Convert.ToString(item["Name"]); } if (item["FieldType"].GetType() != typeof(DBNull)) { formdetail.FieldType = Convert.ToString(item["FieldType"]); } if (item["TableName"].GetType() != typeof(DBNull)) { formdetail.TableName = Convert.ToString(item["TableName"]); } if (item["FormID"].GetType() != typeof(DBNull)) { formdetail.FormID = Convert.ToInt32(item["FormID"]); } formdetails.Add(formdetail); } return(formdetails); }
public static List <FormdetailDataModel> GetAll() { List <FormdetailDataModel> formdetails = new List <FormdetailDataModel>(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetFormdetails", connection); DataTable results = new DataTable(); adapter.Fill(results); foreach (DataRow item in results.Rows) { FormdetailDataModel formdetail = new FormdetailDataModel(); if (item["ID"].GetType() != typeof(DBNull)) { formdetail.ID = Convert.ToInt32(item["ID"]); } if (item["Name"].GetType() != typeof(DBNull)) { formdetail.Name = Convert.ToString(item["Name"]); } if (item["FieldType"].GetType() != typeof(DBNull)) { formdetail.FieldType = Convert.ToString(item["FieldType"]); } if (item["TableName"].GetType() != typeof(DBNull)) { formdetail.TableName = Convert.ToString(item["TableName"]); } if (item["FormID"].GetType() != typeof(DBNull)) { formdetail.FormID = Convert.ToInt32(item["FormID"]); } formdetails.Add(formdetail); } return(formdetails); }
public ActionResult DisplayFormField(FormdetailDataModel model) { return(View(model)); }
public virtual void Create(FormdetailDataModel formdetail) { FormdetailDAL.Create(formdetail); }