public static COMN_Remark GetCOMN_RowStatusByRowStatusID(int RowStatusID)
{
COMN_Remark cOMN_Remark = new COMN_Remark();
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
cOMN_Remark = sqlCOMN_RemarkProvider.GetCOMN_RemarkByRowStatusID(RowStatusID);
return cOMN_Remark;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
COMN_Remark cOMN_Remark = new COMN_Remark ();
cOMN_Remark.RemarkID= int.Parse(Request.QueryString["ID"].ToString());
cOMN_Remark.RemarkName= txtRemarkName.Text;
cOMN_Remark.Remark= txtRemark.Text;
cOMN_Remark.RemarkDate= DateTime.Parse(txtRemarkDate.Text);
cOMN_Remark.WhoReported= txtWhoReported.Text;
cOMN_Remark.WhoDid = processWhoDid();
cOMN_Remark.ExtraField1= txtExtraField1.Text;
cOMN_Remark.ExtraField2= txtExtraField2.Text;
cOMN_Remark.ExtraField3= txtExtraField3.Text;
cOMN_Remark.ExtraField4= txtExtraField4.Text;
cOMN_Remark.ExtraField5= txtExtraField5.Text;
cOMN_Remark.AddedBy= Profile.card_id;
cOMN_Remark.AddedDate= DateTime.Now;
cOMN_Remark.UpdatedBy= Profile.card_id;
cOMN_Remark.UpdatedDate= DateTime.Now;
cOMN_Remark.RowStatusID = 1;// int.Parse(ddlRowStatusID.SelectedValue);
bool resutl =COMN_RemarkManager.UpdateCOMN_Remark(cOMN_Remark);
Response.Redirect("AdminDisplayCOMN_Remark.aspx");
}
private void showCOMN_RemarkData()
{
COMN_Remark cOMN_Remark = new COMN_Remark ();
cOMN_Remark = COMN_RemarkManager.GetCOMN_RemarkByRemarkID(Int32.Parse(Request.QueryString["ID"]));
txtRemarkName.Text =cOMN_Remark.RemarkName.ToString();
txtRemark.Text =cOMN_Remark.Remark.ToString();
txtRemarkDate.Text =cOMN_Remark.RemarkDate.ToString();
txtWhoReported.Text =cOMN_Remark.WhoReported.ToString();
txtWhoDid.Text =cOMN_Remark.WhoDid.ToString();
txtExtraField1.Text =cOMN_Remark.ExtraField1.ToString();
txtExtraField2.Text =cOMN_Remark.ExtraField2.ToString();
txtExtraField3.Text =cOMN_Remark.ExtraField3.ToString();
txtExtraField4.Text =cOMN_Remark.ExtraField4.ToString();
txtExtraField5.Text =cOMN_Remark.ExtraField5.ToString();
ddlRowStatusID.SelectedValue =cOMN_Remark.RowStatusID.ToString();
}
public static int InsertCOMN_Remark(COMN_Remark cOMN_Remark)
{
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
return sqlCOMN_RemarkProvider.InsertCOMN_Remark(cOMN_Remark);
}
public static bool UpdateCOMN_Remark(COMN_Remark cOMN_Remark)
{
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
return sqlCOMN_RemarkProvider.UpdateCOMN_Remark(cOMN_Remark);
}
public COMN_Remark GetCOMN_RemarkFromReader(IDataReader reader)
{
try
{
COMN_Remark cOMN_Remark = new COMN_Remark
(
DataAccessObject.IsNULL<int>(reader["RemarkID"]),
DataAccessObject.IsNULL<string>(reader["RemarkName"]),
DataAccessObject.IsNULL<string>(reader["Remark"]),
DataAccessObject.IsNULL<DateTime>(reader["RemarkDate"]),
DataAccessObject.IsNULL<string>(reader["WhoReported"]),
DataAccessObject.IsNULL<string>(reader["WhoDid"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return cOMN_Remark;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateCOMN_Remark(COMN_Remark cOMN_Remark)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateCOMN_Remark", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RemarkID", SqlDbType.Int).Value = cOMN_Remark.RemarkID;
cmd.Parameters.Add("@RemarkName", SqlDbType.NVarChar).Value = cOMN_Remark.RemarkName;
cmd.Parameters.Add("@Remark", SqlDbType.NText).Value = cOMN_Remark.Remark;
cmd.Parameters.Add("@RemarkDate", SqlDbType.DateTime).Value = cOMN_Remark.RemarkDate;
cmd.Parameters.Add("@WhoReported", SqlDbType.NVarChar).Value = cOMN_Remark.WhoReported;
cmd.Parameters.Add("@WhoDid", SqlDbType.NVarChar).Value = cOMN_Remark.WhoDid;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = cOMN_Remark.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = cOMN_Remark.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = cOMN_Remark.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = cOMN_Remark.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = cOMN_Remark.ExtraField5;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = cOMN_Remark.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = cOMN_Remark.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = cOMN_Remark.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
