public Int32 Save(PromoDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSavePromo(@PromoID, @PromoCode, @PromoName, @StartDate, @EndDate, @PromoTypeID, @Status, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("PromoID", Details.PromoID);
cmd.Parameters.AddWithValue("PromoCode", Details.PromoCode);
cmd.Parameters.AddWithValue("PromoName", Details.PromoName);
cmd.Parameters.AddWithValue("StartDate", Details.StartDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("EndDate", Details.EndDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("PromoTypeID", Details.PromoTypeID);
cmd.Parameters.AddWithValue("Status", Details.Status);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(PromoDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(PromoDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAstDataTable(PromoDetails SearchKey, string SortField = "PromoID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoID, " +
"PromoCode, " +
"PromoName, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromo a INNER JOIN " +
"tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE 1=1 ";
if (!string.IsNullOrEmpty(SearchKey.PromoCode))
{
SQL += "AND PromoCode LIKE @PromoCode ";
cmd.Parameters.AddWithValue("@PromoCode", SearchKey.PromoCode);
}
if (!string.IsNullOrEmpty(SearchKey.PromoName))
{
SQL += "AND PromoCode LIKE @PromoName ";
cmd.Parameters.AddWithValue("@PromoName", SearchKey.PromoName);
}
if (!string.IsNullOrEmpty(SearchKey.PromoTypeCode))
{
SQL += "AND PromoCode LIKE @PromoTypeCode ";
cmd.Parameters.AddWithValue("@PromoTypeCode", SearchKey.PromoTypeCode);
}
SQL += "ORDER BY " + SortField + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return(dt);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(PromoDetails Details)
{
try
{
Save(Details);
return Int64.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(PromoDetails Details)
{
try
{
Save(Details);
return(Int64.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PromoDetails Details(Int64 PromoID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoID, " +
"PromoCode, " +
"PromoName, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromo a " +
"INNER JOIN tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE a.PromoID = @PromoID;";
cmd.Parameters.AddWithValue("@PromoID", PromoID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
PromoDetails Details = new PromoDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.PromoID = Int64.Parse(dr["PromoID"].ToString());
Details.PromoCode = "" + dr["PromoCode"].ToString();
Details.PromoName = "" + dr["PromoName"].ToString();
Details.StartDate = DateTime.Parse(dr["StartDate"].ToString());
Details.EndDate = DateTime.Parse(dr["EndDate"].ToString());
Details.PromoTypeID = Int32.Parse(dr["PromoTypeID"].ToString());
Details.PromoTypeCode = "" + dr["PromoTypeCode"].ToString();
Details.PromoTypeName = "" + dr["PromoTypeName"].ToString();
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void LoadList()
{
Promo clsPromo = new Promo();
DataClass clsDataClass = new DataClass();
string SortField = "PromoName";
if (Request.QueryString["sortfield"]!=null)
{ SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); }
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"]!=null)
{ sortoption = (SortOption) Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }
PromoDetails clsSearchKey = new PromoDetails();
if (Request.QueryString["Search"]!=null)
{
clsSearchKey.PromoCode = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
}
PageData.DataSource = clsPromo.ListAstDataTable(clsSearchKey, SortField, sortoption).DefaultView;
clsPromo.CommitAndDispose();
int iPageSize = Convert.ToInt16(Session["PageSize"]) ;
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i=0; i < PageData.PageCount;i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{ cboCurrentPage.Items[i].Selected = true;}
else
{ cboCurrentPage.Items[i].Selected = false;}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
private Int64 SaveRecord()
{
long lngRetValue = 0;
string stScript = string.Empty;
DateTime dteStartDateTime = DateTime.MinValue;
try { dteStartDateTime = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch {
stScript += "<Script>";
stScript += "window.alert('Please enter a valid start date time of promo.')";
stScript += "</Script>";
Response.Write(stScript);
return lngRetValue ;
}
DateTime dteEndDateTime = DateTime.MinValue;
try { dteEndDateTime = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch
{
stScript += "<Script>";
stScript += "window.alert('Please enter a valid end date time of promo.')";
stScript += "</Script>";
Response.Write(stScript);
return lngRetValue;
}
Promo clsPromo = new Promo();
PromoDetails clsDetails = new PromoDetails();
clsDetails.PromoCode = txtPromoCode.Text;
clsDetails.PromoName = txtPromoName.Text;
clsDetails.StartDate = dteStartDateTime;
clsDetails.EndDate = dteEndDateTime;
clsDetails.PromoTypeID = Convert.ToInt32(cboPromoType.SelectedItem.Value);
lngRetValue = clsPromo.Insert(clsDetails);
clsPromo.CommitAndDispose();
return lngRetValue;
}
public Int32 Save(PromoDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSavePromo(@PromoID, @PromoCode, @PromoName, @StartDate, @EndDate, @PromoTypeID, @Status, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("PromoID", Details.PromoID);
cmd.Parameters.AddWithValue("PromoCode", Details.PromoCode);
cmd.Parameters.AddWithValue("PromoName", Details.PromoName);
cmd.Parameters.AddWithValue("StartDate", Details.StartDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("EndDate", Details.EndDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("PromoTypeID", Details.PromoTypeID);
cmd.Parameters.AddWithValue("Status", Details.Status);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAstDataTable(PromoDetails SearchKey, string SortField = "PromoID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoID, " +
"PromoCode, " +
"PromoName, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromo a INNER JOIN " +
"tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE 1=1 ";
if (!string.IsNullOrEmpty(SearchKey.PromoCode))
{
SQL += "AND PromoCode LIKE @PromoCode ";
cmd.Parameters.AddWithValue("@PromoCode", SearchKey.PromoCode);
}
if (!string.IsNullOrEmpty(SearchKey.PromoName))
{
SQL += "AND PromoCode LIKE @PromoName ";
cmd.Parameters.AddWithValue("@PromoName", SearchKey.PromoName);
}
if (!string.IsNullOrEmpty(SearchKey.PromoTypeCode))
{
SQL += "AND PromoCode LIKE @PromoTypeCode ";
cmd.Parameters.AddWithValue("@PromoTypeCode", SearchKey.PromoTypeCode);
}
SQL += "ORDER BY " + SortField + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PromoDetails Details(Int64 PromoID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL= "SELECT " +
"PromoID, " +
"PromoCode, " +
"PromoName, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromo a " +
"INNER JOIN tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE a.PromoID = @PromoID;";
cmd.Parameters.AddWithValue("@PromoID", PromoID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
PromoDetails Details = new PromoDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.PromoID = Int64.Parse(dr["PromoID"].ToString());
Details.PromoCode = "" + dr["PromoCode"].ToString();
Details.PromoName = "" + dr["PromoName"].ToString();
Details.StartDate = DateTime.Parse(dr["StartDate"].ToString());
Details.EndDate = DateTime.Parse(dr["EndDate"].ToString());
Details.PromoTypeID = Int32.Parse(dr["PromoTypeID"].ToString());
Details.PromoTypeCode = "" + dr["PromoTypeCode"].ToString();
Details.PromoTypeName = "" + dr["PromoTypeName"].ToString();
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}