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;
}
}
