protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblMonthTypeID = GridView1.Rows[e.RowIndex].FindControl("lblMonthTypeID") as Label;
TextBox txtTitle = GridView1.Rows[e.RowIndex].FindControl("txtTitle") as TextBox;
if (lblMonthTypeID != null && txtTitle != null)
{
MonthType monthType = new MonthType();
monthType.MonthTypeID = Convert.ToInt32(lblMonthTypeID.Text.Trim());
monthType.Title = txtTitle.Text;
//Let us now update the database
if (monthTypeHandler.Update(monthType) == true)
{
lblResult.Text = "Record Updated Successfully";
}
else
{
lblResult.Text = "Failed to Update record";
}
//end the editing and bind with updated records.
GridView1.EditIndex = -1;
BindData();
}
}
public List <MonthType> SearchLike(MonthType monthType)
{
List <MonthType> listMonthType = new List <MonthType>();
SqlParameter[] parametersMonthType = new SqlParameter[]
{
new SqlParameter("@MonthTypeID", monthType.MonthTypeID),
new SqlParameter("@Title", monthType.Title),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MonthType_SearchLike", CommandType.StoredProcedure, parametersMonthType))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
MonthType tmpMonthType = new MonthType();
tmpMonthType.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
tmpMonthType.Title = row["Title"].ToString();
listMonthType.Add(tmpMonthType);
}
}
}
return(listMonthType);
}
public bool Exists(MonthType monthType)
{
SqlParameter[] parametersMonthType = new SqlParameter[]
{
new SqlParameter("@MonthTypeID", monthType.MonthTypeID)
};
return(SqlDBHelper.ExecuteScalar("MonthType_Exists", CommandType.StoredProcedure, parametersMonthType) > 0);
}
public Month() : base()
{
Year = new SaveableXmlElement <IYear>();
MonthType = (MonthEnum)DateTime.Now.Month;
AlignedMonths = new AlignedMonths(this);
Transactions = new ElementCollection <ITransaction>();
Name = MonthType.ConvertToText();
Types = new CategoryTypeCollection();
}
public Int64 Insert(MonthType monthType)
{
SqlParameter[] parametersMonthType = new SqlParameter[]
{
new SqlParameter("@Title", (monthType.Title != null) ? monthType.Title : (object)DBNull.Value)
};
monthType.MonthTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("MonthType_Insert", CommandType.StoredProcedure, parametersMonthType));
return(monthType.MonthTypeID);
}
public bool Update(MonthType monthType)
{
SqlParameter[] parametersMonthType = new SqlParameter[]
{
new SqlParameter("@MonthTypeID", monthType.MonthTypeID),
new SqlParameter("@Title", (monthType.Title != null) ? monthType.Title : (object)DBNull.Value)
};
return(SqlDBHelper.ExecuteNonQuery("MonthType_Update", CommandType.StoredProcedure, parametersMonthType));
}
protected void btnYES_Click(object sender, EventArgs e)
{
MonthType monthType = new MonthType();
monthType.Title = txtTitle.Text;
MonthTypeHandler monthTypeHandler = new MonthTypeHandler();
if (monthTypeHandler.Insert(monthType) > 0)
{
Response.Redirect("Z_MonthTypeDefault.aspx");
}
}
private void btn_generate_card_Click(object sender, EventArgs e)
{
string guid = Guid.NewGuid().ToString();
guid = guid.Substring(guid.IndexOf('-') + 1, 14);
txbx_card_number.Text = guid.ToUpper();
Random random = new Random();
int number = random.Next(0, 4);
CardAmountType[] enumValues = (CardAmountType[])Enum.GetValues(typeof(CardAmountType));
CardAmountType cardAmountType = enumValues[number];
txbx_card_amoun.Text = ((int)cardAmountType).ToString();
CardData cardData = new CardData();
MonthType monthType = cardData.GetDataByAmountType(cardAmountType);
txbx_card_expire_date.Text = DateTime.Now.AddMonths((int)monthType).ToString();
}
public MonthType GetDetails(int monthTypeID)
{
MonthType monthType = new MonthType();
SqlParameter[] parametersMonthType = new SqlParameter[]
{
new SqlParameter("@MonthTypeID", monthTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MonthType_GetDetails", CommandType.StoredProcedure, parametersMonthType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
monthType.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
monthType.Title = row["Title"].ToString();
}
}
return(monthType);
}
public List <MonthType> GetListAll()
{
List <MonthType> listMonthType = null;
using (DataTable table = SqlDBHelper.ExecuteSelectCommand("MonthType_GetListAll", CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
listMonthType = new List <MonthType>();
foreach (DataRow row in table.Rows)
{
MonthType monthType = new MonthType();
monthType.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
monthType.Title = row["Title"].ToString();
listMonthType.Add(monthType);
}
}
}
return(listMonthType);
}
protected void Page_Load(object sender, EventArgs e)
{
string monthTypeID = Request.QueryString["monthTypeID"] as string;
if (monthTypeID == null)
{
Response.Redirect("Z_MonthTypeDefault.aspx");
}
try
{
monthTypeMonthTypeID = Convert.ToInt32(monthTypeID.Trim());
monthTypeHandler = new MonthTypeHandler();
MonthType monthType = monthTypeHandler.GetDetails(monthTypeMonthTypeID);
lblMonthTypeID.Text = monthType.MonthTypeID.ToString();
lblTitle.Text = monthType.Title.ToString();
}
catch (Exception)
{
Response.Redirect("Z_MonthTypeDefault.aspx");
}
}
public Month(MonthType monthType, Year year)
{
this.MonthType = monthType;
this.Year = year;
}
public DayViewModel(int no, MonthType monthType, GKSchedule calendar)
{
Schedule = calendar;
var dateTime = new DateTime(Schedule.Year, (int)monthType, no);
DayOfWeek = dateTime.DayOfWeek;
MonthType = monthType;
No = no;
SelectCommand = new RelayCommand(OnSelect);
}
public MonthViewModel(MonthType monthType, GKSchedule calendar)
{
Schedule = calendar;
MonthType = monthType;
Update(Schedule.Year);
}
