public DataTable ReturnDatatable( int advantage_id, string title, string url, string mdate, string cdate, int status, int flag) { DataTable dt = new DataTable(); DataAccess da = new DataAccess(); try { SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@advantage_id", DbType.Int32); param[0].Value = advantage_id; param[1] = new SqlParameter("@title", DbType.String); param[1].Value = title; param[2] = new SqlParameter("@url", DbType.String); param[2].Value = url; if (mdate == "") { param[3] = new SqlParameter("@mdate", DbType.DateTime); param[3].Value = mdate; } else { param[3] = new SqlParameter("@mdate", DbType.DateTime); param[3].Value = Convert.ToDateTime(mdate); } if (cdate == "") { param[4] = new SqlParameter("@cdate", DbType.DateTime); param[4].Value = cdate; } else { param[4] = new SqlParameter("@cdate", DbType.DateTime); param[4].Value = Convert.ToDateTime(cdate); } param[5] = new SqlParameter("@status", DbType.Int32); param[5].Value = status; param[6] = new SqlParameter("@flag", DbType.Int32); param[6].Value = flag; dt = da.GetDataTable("Advantages", param); return dt; } catch (Exception) { return dt; throw; } }
public DataTable ReturnDatatable( int worker_id, string name, string image, string description, string mdate, string cdate, int status, int flag) { DataTable dt = new DataTable(); DataAccess da = new DataAccess(); try { SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@worker_id", DbType.Int32); param[0].Value = worker_id; param[1] = new SqlParameter("@name", DbType.String); param[1].Value = name; param[2] = new SqlParameter("@image", DbType.String); param[2].Value = image; param[3] = new SqlParameter("@description", DbType.String); param[3].Value = description; if (mdate == "") { param[4] = new SqlParameter("@mdate", DbType.DateTime); param[4].Value = mdate; } else { param[4] = new SqlParameter("@mdate", DbType.DateTime); param[4].Value = Convert.ToDateTime(mdate); } if (cdate == "") { param[5] = new SqlParameter("@cdate", DbType.DateTime); param[5].Value = cdate; } else { param[5] = new SqlParameter("@cdate", DbType.DateTime); param[5].Value = Convert.ToDateTime(cdate); } param[6] = new SqlParameter("@status", DbType.Int32); param[6].Value = status; param[7] = new SqlParameter("@flag", DbType.Int32); param[7].Value = flag; dt = da.GetDataTable("Workteam", param); return dt; } catch (Exception) { return dt; throw; } }