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);
}
