public static ACC_JournalInfoForDelete GetACC_RowStatusByRowStatusID(int RowStatusID) { ACC_JournalInfoForDelete aCC_JournalInfoForDelete = new ACC_JournalInfoForDelete(); SqlACC_JournalInfoForDeleteProvider sqlACC_JournalInfoForDeleteProvider = new SqlACC_JournalInfoForDeleteProvider(); aCC_JournalInfoForDelete = sqlACC_JournalInfoForDeleteProvider.GetACC_JournalInfoForDeleteByRowStatusID(RowStatusID); return aCC_JournalInfoForDelete; }
private void showACC_JournalInfoForDeleteData() { ACC_JournalInfoForDelete aCC_JournalInfoForDelete = new ACC_JournalInfoForDelete (); aCC_JournalInfoForDelete = ACC_JournalInfoForDeleteManager.GetACC_JournalInfoForDeleteByJournalID(Int32.Parse(Request.QueryString["ID"])); txtTableNameValue.Text =aCC_JournalInfoForDelete.TableNameValue.ToString(); ddlRowStatusID.SelectedValue =aCC_JournalInfoForDelete.RowStatusID.ToString(); }
public static ACC_JournalInfoForDelete GetACC_JournalInfoForDeleteByJournalID(int JournalID) { ACC_JournalInfoForDelete aCC_JournalInfoForDelete = new ACC_JournalInfoForDelete(); SqlACC_JournalInfoForDeleteProvider sqlACC_JournalInfoForDeleteProvider = new SqlACC_JournalInfoForDeleteProvider(); aCC_JournalInfoForDelete = sqlACC_JournalInfoForDeleteProvider.GetACC_JournalInfoForDeleteByJournalID(JournalID); return aCC_JournalInfoForDelete; }
protected void btnUpdate_Click(object sender, EventArgs e) { ACC_JournalInfoForDelete aCC_JournalInfoForDelete = new ACC_JournalInfoForDelete (); aCC_JournalInfoForDelete.JournalID= int.Parse(Request.QueryString["ID"].ToString()); aCC_JournalInfoForDelete.TableNameValue= txtTableNameValue.Text; aCC_JournalInfoForDelete.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; aCC_JournalInfoForDelete.UpdateDate= DateTime.Now; aCC_JournalInfoForDelete.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); bool resutl =ACC_JournalInfoForDeleteManager.UpdateACC_JournalInfoForDelete(aCC_JournalInfoForDelete); Response.Redirect("AdminDisplayACC_JournalInfoForDelete.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { ACC_JournalInfoForDelete aCC_JournalInfoForDelete = new ACC_JournalInfoForDelete (); // aCC_JournalInfoForDelete.JournalID= int.Parse(ddlJournalID.SelectedValue); aCC_JournalInfoForDelete.TableNameValue= txtTableNameValue.Text; aCC_JournalInfoForDelete.UpdatedBy= "530038e1-cf38-4ddb-84a4-99b6974b4f9d"; aCC_JournalInfoForDelete.UpdateDate= DateTime.Now; aCC_JournalInfoForDelete.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue); int resutl =ACC_JournalInfoForDeleteManager.InsertACC_JournalInfoForDelete(aCC_JournalInfoForDelete); Response.Redirect("AdminDisplayACC_JournalInfoForDelete.aspx"); }
public static int InsertACC_JournalInfoForDelete(ACC_JournalInfoForDelete aCC_JournalInfoForDelete) { SqlACC_JournalInfoForDeleteProvider sqlACC_JournalInfoForDeleteProvider = new SqlACC_JournalInfoForDeleteProvider(); return sqlACC_JournalInfoForDeleteProvider.InsertACC_JournalInfoForDelete(aCC_JournalInfoForDelete); }
public static bool UpdateACC_JournalInfoForDelete(ACC_JournalInfoForDelete aCC_JournalInfoForDelete) { SqlACC_JournalInfoForDeleteProvider sqlACC_JournalInfoForDeleteProvider = new SqlACC_JournalInfoForDeleteProvider(); return sqlACC_JournalInfoForDeleteProvider.UpdateACC_JournalInfoForDelete(aCC_JournalInfoForDelete); }
public ACC_JournalInfoForDelete GetACC_JournalInfoForDeleteFromReader(IDataReader reader) { try { ACC_JournalInfoForDelete aCC_JournalInfoForDelete = new ACC_JournalInfoForDelete ( DataAccessObject.IsNULL<int>(reader["JournalID"]), DataAccessObject.IsNULL<string>(reader["TableNameValue"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]), DataAccessObject.IsNULL<int>(reader["RowStatusID"]) ); return aCC_JournalInfoForDelete; } catch(Exception ex) { return null; } }
public bool UpdateACC_JournalInfoForDelete(ACC_JournalInfoForDelete aCC_JournalInfoForDelete) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateACC_JournalInfoForDelete", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@JournalID", SqlDbType.Int).Value = aCC_JournalInfoForDelete.JournalID; cmd.Parameters.Add("@TableNameValue", SqlDbType.NText).Value = aCC_JournalInfoForDelete.TableNameValue; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_JournalInfoForDelete.UpdatedBy; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_JournalInfoForDelete.UpdateDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_JournalInfoForDelete.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }