public static STD_FeesType GetCOMN_RowStatusByRowStatusID(int RowStatusID) { STD_FeesType sTD_FeesType = new STD_FeesType(); SqlSTD_FeesTypeProvider sqlSTD_FeesTypeProvider = new SqlSTD_FeesTypeProvider(); sTD_FeesType = sqlSTD_FeesTypeProvider.GetSTD_FeesTypeByRowStatusID(RowStatusID); return sTD_FeesType; }
public static STD_FeesType GetSTD_FeesTypeByFeesTypeID(int FeesTypeID) { STD_FeesType sTD_FeesType = new STD_FeesType(); SqlSTD_FeesTypeProvider sqlSTD_FeesTypeProvider = new SqlSTD_FeesTypeProvider(); sTD_FeesType = sqlSTD_FeesTypeProvider.GetSTD_FeesTypeByFeesTypeID(FeesTypeID); return sTD_FeesType; }
private void showSTD_FeesTypeData() { STD_FeesType sTD_FeesType = new STD_FeesType (); sTD_FeesType = STD_FeesTypeManager.GetSTD_FeesTypeByFeesTypeID(Int32.Parse(Request.QueryString["ID"])); txtFeesTypeName.Text =sTD_FeesType.FeesTypeName.ToString(); ddlRowStatusID.SelectedValue =sTD_FeesType.RowStatusID.ToString(); }
protected void btnUpdate_Click(object sender, EventArgs e) { STD_FeesType sTD_FeesType = new STD_FeesType (); sTD_FeesType.FeesTypeID= int.Parse(Request.QueryString["ID"].ToString()); sTD_FeesType.FeesTypeName= txtFeesTypeName.Text; sTD_FeesType.AddedBy= Profile.card_id; sTD_FeesType.AddedDate= DateTime.Now; sTD_FeesType.UpdatedBy= Profile.card_id; sTD_FeesType.UpdateDate= DateTime.Now; sTD_FeesType.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); bool resutl =STD_FeesTypeManager.UpdateSTD_FeesType(sTD_FeesType); Response.Redirect("AdminDisplaySTD_FeesType.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { STD_FeesType sTD_FeesType = new STD_FeesType (); // sTD_FeesType.FeesTypeID= int.Parse(ddlFeesTypeID.SelectedValue); sTD_FeesType.FeesTypeName= txtFeesTypeName.Text; sTD_FeesType.AddedBy= Profile.card_id; sTD_FeesType.AddedDate= DateTime.Now; sTD_FeesType.UpdatedBy= Profile.card_id; sTD_FeesType.UpdateDate= DateTime.Now; sTD_FeesType.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); int resutl =STD_FeesTypeManager.InsertSTD_FeesType(sTD_FeesType); Response.Redirect("AdminDisplaySTD_FeesType.aspx"); }
public static bool UpdateSTD_FeesType(STD_FeesType sTD_FeesType) { SqlSTD_FeesTypeProvider sqlSTD_FeesTypeProvider = new SqlSTD_FeesTypeProvider(); return sqlSTD_FeesTypeProvider.UpdateSTD_FeesType(sTD_FeesType); }
public static int InsertSTD_FeesType(STD_FeesType sTD_FeesType) { SqlSTD_FeesTypeProvider sqlSTD_FeesTypeProvider = new SqlSTD_FeesTypeProvider(); return sqlSTD_FeesTypeProvider.InsertSTD_FeesType(sTD_FeesType); }
public bool UpdateSTD_FeesType(STD_FeesType sTD_FeesType) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateSTD_FeesType", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FeesTypeID", SqlDbType.Int).Value = sTD_FeesType.FeesTypeID; cmd.Parameters.Add("@FeesTypeName", SqlDbType.NVarChar).Value = sTD_FeesType.FeesTypeName; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_FeesType.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_FeesType.UpdateDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_FeesType.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public STD_FeesType GetSTD_FeesTypeFromReader(IDataReader reader) { try { STD_FeesType sTD_FeesType = new STD_FeesType ( DataAccessObject.IsNULL<int>(reader["FeesTypeID"]), DataAccessObject.IsNULL<string>(reader["FeesTypeName"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]), DataAccessObject.IsNULL<int>(reader["RowStatusID"]) ); return sTD_FeesType; } catch(Exception ex) { return null; } }