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 void ReturnVoid(
int worker_id,
string name,
string image,
string description,
string mdate,
string cdate,
int status,
int flag)
{
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;
param[4] = new SqlParameter("@mdate", DbType.DateTime);
param[4].Value = mdate;
param[5] = new SqlParameter("@cdate", DbType.DateTime);
param[5].Value = cdate;
param[6] = new SqlParameter("@status", DbType.Int32);
param[6].Value = status;
param[7] = new SqlParameter("@flag", DbType.Int32);
param[7].Value = flag;
da.ExeNonQuery("Workteam", param);
}
catch (Exception)
{
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;
}
}
public void ReturnVoid(
int slider_id,
string title,
string url,
string image,
string mdate,
string cdate,
int status,
int flag)
{
DataAccess da = new DataAccess();
try
{
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@slider_id", DbType.Int32);
param[0].Value = slider_id;
param[1] = new SqlParameter("@title", DbType.String);
param[1].Value = title;
param[2] = new SqlParameter("@url", DbType.String);
param[2].Value = url;
param[3] = new SqlParameter("@image", DbType.String);
param[3].Value = image;
param[4] = new SqlParameter("@mdate", DbType.DateTime);
param[4].Value = mdate;
param[5] = new SqlParameter("@cdate", DbType.DateTime);
param[5].Value = cdate;
param[6] = new SqlParameter("@status", DbType.Int32);
param[6].Value = status;
param[7] = new SqlParameter("@flag", DbType.Int32);
param[7].Value = flag;
da.ExeNonQuery("banner", param);
}
catch (Exception)
{
throw;
}
}
public void ReturnVoid(
int port_id,
string title,
string image,
string imageurl,
string description,
string mdate,
string cdate,
int status,
int flag)
{
DataAccess da = new DataAccess();
try
{
SqlParameter[] param = new SqlParameter[9];
param[0] = new SqlParameter("@port_id", DbType.Int32);
param[0].Value = port_id;
param[1] = new SqlParameter("@title", DbType.String);
param[1].Value = title;
param[2] = new SqlParameter("@image", DbType.String);
param[2].Value = image;
param[3] = new SqlParameter("@imageurl", DbType.String);
param[3].Value = imageurl;
param[4] = new SqlParameter("@description", DbType.String);
param[4].Value = description;
if (mdate == "")
{
param[5] = new SqlParameter("@mdate", DbType.DateTime);
param[5].Value = mdate;
}
else
{
param[5] = new SqlParameter("@mdate", DbType.DateTime);
param[5].Value = Convert.ToDateTime(mdate);
}
if (cdate == "")
{
param[6] = new SqlParameter("@cdate", DbType.DateTime);
param[6].Value = cdate;
}
else
{
param[6] = new SqlParameter("@cdate", DbType.DateTime);
param[6].Value = Convert.ToDateTime(cdate);
}
param[7] = new SqlParameter("@status", DbType.Int32);
param[7].Value = status;
param[8] = new SqlParameter("@flag", DbType.Int32);
param[8].Value = flag;
da.ExeNonQuery("Ports", param);
}
catch (Exception)
{
throw;
}
}