public static bool UpdateGradingDisputeBLL(GradingDisputeBLL obj, SqlTransaction tran)
{
string strSql = "spUpdateGradeDispute";
SqlParameter[] arPar = new SqlParameter[6];
arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
arPar[0].Value = obj.Id;
arPar[1] = new SqlParameter("@ExpectedCommodityGradeId", SqlDbType.UniqueIdentifier);
arPar[1].Value = obj.ExpectedCommodityGradeId;
arPar[2] = new SqlParameter("@DateTimeRequested", SqlDbType.DateTime);
arPar[2].Value = obj.DateTimeRecived;
arPar[3] = new SqlParameter("@Remark", SqlDbType.Text);
arPar[3].Value = obj.Remark;
arPar[4] = new SqlParameter("@Status", SqlDbType.Int);
arPar[4].Value = obj.Status;
arPar[5] = new SqlParameter("@LastModifiedBy", SqlDbType.UniqueIdentifier);
arPar[5].Value = UserBLL.GetCurrentUser();
int AffectedRows = 0;
AffectedRows = SqlHelper.ExecuteNonQuery(tran, strSql, arPar);
if (AffectedRows == 1)
{
return(true);
}
else
{
throw new Exception("Updating Grading Dispute Failed.");
}
}
private void LoadData(Guid Id)
{
Guid GradingId = Guid.Empty;
GradingDisputeBLL obj = new GradingDisputeBLL();
hfId.Value = Id.ToString();
obj = obj.GetById(Id);
ViewState["OldGradingDisputeBLL"] = obj;
if (obj != null)
{
if (obj.GradingId != null)
{
GradingId = obj.GradingId;
GradingBLL objgrading = new GradingBLL();
objgrading = objgrading.GetById(GradingId);
this.lblGradeCode.Text = objgrading.GradingCode.ToString();
}
if (obj.TrackingNo != null)
{
this.hfTrackingNo.Value = obj.TrackingNo;
}
if (obj.DateTimeRecived != null)
{
this.txtDateRecived.Text = obj.DateTimeRecived.ToShortDateString();
this.txtTimeRecived.Text = obj.DateTimeRecived.ToLongTimeString();
}
this.cboStatus.SelectedValue = obj.Status.ToString();
if (obj.Remark != null)
{
this.txtRemark.Text = obj.Remark;
}
if (obj.PreviousCommodityGradeId != null)
{
this.lblPreviousGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(obj.PreviousCommodityGradeId);
}
if (obj.ExpectedCommodityGradeId != null)
{
CommodityGradeBLL objCG = CommodityGradeBLL.GetCommodityGrade(obj.ExpectedCommodityGradeId);
CommodityGradeBLL objCC = CommodityGradeBLL.GetCommodityClassById(objCG.CommodityClassId);
CommodityGradeBLL objC = CommodityGradeBLL.GetCommodityById(objCC.CommodityId);
this.cboCommodity_CascadingDropDown.SelectedValue = objC.CommodityId.ToString();
this.cboCommodityClass_CascadingDropDown.SelectedValue = objCC.CommodityClassId.ToString();
this.cboCommodityGrade_CascadingDropDown.SelectedValue = obj.ExpectedCommodityGradeId.ToString();
}
}
}
public static bool InsertGradingDisputeBLL(GradingDisputeBLL obj, SqlTransaction tran)
{
string strSql = "spInsertGradeDispute";
SqlParameter[] arPar = new SqlParameter[10];
arPar[0] = new SqlParameter("@TransactionId", SqlDbType.NVarChar, 50);
arPar[0].Value = obj.TrackingNo;
arPar[1] = new SqlParameter("@GradingId", SqlDbType.UniqueIdentifier);
arPar[1].Value = obj.GradingId;
arPar[2] = new SqlParameter("@GradingResultId", SqlDbType.UniqueIdentifier);
arPar[2].Value = obj.GradingResultId;
arPar[3] = new SqlParameter("@PrevioudCommodityGradeId", SqlDbType.UniqueIdentifier);
arPar[3].Value = obj.PreviousCommodityGradeId;
arPar[4] = new SqlParameter("@ExpectedCommodityGradeId", SqlDbType.UniqueIdentifier);
arPar[4].Value = obj.ExpectedCommodityGradeId;
arPar[5] = new SqlParameter("@DateTimeRequested", SqlDbType.DateTime);
arPar[5].Value = Convert.ToDateTime(obj.DateTimeRecived);
arPar[6] = new SqlParameter("@Remark", SqlDbType.Text);
arPar[6].Value = obj.Remark;
arPar[7] = new SqlParameter("@Status", SqlDbType.Int);
arPar[7].Value = obj.Status;
arPar[8] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
arPar[8].Value = UserBLL.GetCurrentUser();
arPar[9] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
arPar[9].Value = obj.Id;
int AffectedRows = 0;
AffectedRows = SqlHelper.ExecuteNonQuery(tran, strSql, arPar);
if (AffectedRows == 1)
{
return(true);
}
else
{
throw new Exception("Adding Grading Dispute Failed.");
}
}
public static string GetTrackingNumberBySamplingResultId(Guid SamplingId)
{
GradingDisputeBLL obj = new GradingDisputeBLL();
string strSql = "spGetGradingDisputeTrackingNo";
SqlParameter[] arPar = new SqlParameter[2];
SqlDataReader reader;
arPar[0] = new SqlParameter("@SamplingResultId", SqlDbType.UniqueIdentifier);
arPar[0].Value = SamplingId;
arPar[1] = new SqlParameter("@warehouseId", SqlDbType.UniqueIdentifier);
arPar[1].Value = UserBLL.GetCurrentWarehouse();
SqlConnection conn = Connection.getConnection();
if (conn == null || conn.State != ConnectionState.Open)
{
throw new Exception("Invalid database connection.");
}
try
{
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
}
catch (Exception e)
{
throw e;
}
if (reader.HasRows)
{
reader.Read();
return(reader["TransactionId"].ToString());
}
else
{
return("");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Guid GradingId = Guid.Empty;
if (this.cboGradingCode.SelectedValue != "")
{
try
{
GradingId = new Guid(this.cboGradingCode.SelectedValue.ToString());
}
catch
{
this.lblMsg.Text = "Please select Grading code.";
return;
}
}
else
{
this.lblMsg.Text = "Please select Grading code.";
return;
}
Guid GradingResultId = Guid.Empty;
if (this.hfGradingResultId.Value != "")
{
try
{
GradingResultId = new Guid(hfGradingResultId.Value.ToString());
}
catch
{
this.lblMsg.Text = "Please select Grading code.";
return;
}
}
else
{
this.lblMsg.Text = "Please select Grading code.";
return;
}
Guid PrevioudCommodityGradeId = Guid.Empty;
if (this.hfPreviousGradingResult.Value != "")
{
try
{
PrevioudCommodityGradeId = new Guid(this.hfPreviousGradingResult.Value.ToString());
}
catch
{
this.lblMsg.Text = "Please select Grading code.";
return;
}
}
else
{
this.lblMsg.Text = "Please select Grading code.";
return;
}
Guid ExpectedCommodityGradeId = Guid.Empty;
if (this.cboCommodityGrade.SelectedValue != "")
{
try
{
ExpectedCommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString());
}
catch
{
}
}
else
{
this.lblMsg.Text = "Please select Commodity Grade.";
return;
}
DateTime DateTimeRequested;
if (this.txtDateRecived.Text != "" && this.txtTimeRecived.Text != "")
{
try
{
DateTimeRequested = Convert.ToDateTime(this.txtDateRecived.Text.Trim() + " " + this.txtTimeRecived.Text.Trim());
}
catch
{
this.lblMsg.Text = "Date format is not correct.";
return;
}
}
else
{
this.lblMsg.Text = "Please enter date time.";
return;
}
string Remark;
Remark = this.txtRemark.Text;
int Status;
Status = 1;// new
//add
bool isSaved = false;
GradingDisputeBLL objGradeDispute = new GradingDisputeBLL();
objGradeDispute.Id = Guid.NewGuid();
objGradeDispute.GradingId = GradingId;
objGradeDispute.GradingResultId = GradingResultId;
objGradeDispute.PreviousCommodityGradeId = PrevioudCommodityGradeId;
objGradeDispute.ExpectedCommodityGradeId = ExpectedCommodityGradeId;
objGradeDispute.DateTimeRecived = DateTimeRequested;
objGradeDispute.Remark = Remark;
objGradeDispute.Status = Status;
try
{
isSaved = objGradeDispute.Add();
if (isSaved == true)
{
this.lblMsg.Text = "Data added Successfully";
Clear();
if (Session["CoffeeRegradeTranNo"] != null)
{
Response.Redirect("PageSwicther.aspx?TranNo=" + Session["CoffeeRegradeTranNo"].ToString());
}
}
else
{
this.lblMsg.Text = "The record can not be added.";
}
}
catch (Exception ex)
{
this.lblMsg.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Guid Id = Guid.Empty;
Guid ExpectedCommodityGradeId = Guid.Empty;
DateTime DateTimeRequested;
string Remark;
int Status;
#region AcceptingData
if (hfId.Value != null)
{
try
{
Id = new Guid(hfId.Value.ToString());
}
catch
{
this.lblMsg.Text = "Unable to load all data please try Again";
return;
}
}
else
{
this.lblMsg.Text = "Unable to load all data please try Again";
return;
}
if (hfGradingResultId.Value != "")
{
try
{
Id = new Guid(hfGradingResultId.Value.ToString());
}
catch
{
this.lblMsg.Text = "Unable to load all data please try Again";
return;
}
}
if (this.cboCommodityGrade.SelectedValue != "")
{
try
{
ExpectedCommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString());
}
catch
{
this.lblMsg.Text = "Unable to load all data please try Again";
return;
}
}
if (this.txtDateRecived.Text != "" && this.txtTimeRecived.Text != "")
{
try
{
DateTimeRequested = Convert.ToDateTime(this.txtDateRecived.Text + " " + this.txtTimeRecived.Text);
}
catch
{
this.lblMsg.Text = "Please check date Time recived";
return;
}
}
else
{
this.lblMsg.Text = "Please check date Time recived.";
return;
}
Remark = this.txtRemark.Text;
string x;
x = this.cboStatus.SelectedItem.Text;
if (this.cboStatus.SelectedValue != "")
{
try
{
Status = Convert.ToInt32(this.cboStatus.SelectedValue.ToString());
}
catch
{
this.lblMsg.Text = "Please check Status.";
return;
}
}
else
{
this.lblMsg.Text = "Please check Status.";
return;
}
#endregion
GradingDisputeBLL objGradeDispute = new GradingDisputeBLL();
GradingDisputeBLL objOld = (GradingDisputeBLL)ViewState["OldGradingDisputeBLL"];
objGradeDispute.Id = Id;
objGradeDispute.ExpectedCommodityGradeId = ExpectedCommodityGradeId;
objGradeDispute.DateTimeRecived = DateTimeRequested;
objGradeDispute.Remark = Remark;
objGradeDispute.Status = Status;
objGradeDispute.TrackingNo = this.hfTrackingNo.Value;
bool isSaved = false;
try
{
isSaved = objGradeDispute.Edit(objOld);
if (isSaved == true)
{
this.lblMsg.Text = "Update Sucessfull";
if (Session["EditGradeDisputeTranNo"] != null)
{
Response.Redirect("PageSwicther.aspx?TranNo=" + Session["EditGradeDisputeTranNo"].ToString());
}
else
{
if (objGradeDispute.Status == 2)
{
this.lblMsg.Text = "Unable to update data.";
}
else
{
this.lblMsg.Text = "Data Updated Successfully";
}
}
}
}
catch (Exception exc)
{
this.lblMsg.Text = exc.Message;
}
}
public static GradingDisputeBLL GetById(Guid Id)
{
GradingDisputeBLL obj = new GradingDisputeBLL();
string strSql = "spGetGradingDisputeById";
SqlParameter[] arPar = new SqlParameter[1];
SqlDataReader reader;
arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
arPar[0].Value = Id;
SqlConnection conn = Connection.getConnection();
if (conn == null || conn.State != ConnectionState.Open)
{
throw new Exception("Invalid database connection.");
}
try
{
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
reader.Read();
obj.Id = new Guid(reader["Id"].ToString());
obj.TrackingNo = reader["TransactionId"].ToString();
obj.GradingId = new Guid(reader["GradingId"].ToString());
obj.GradingResultId = new Guid(reader["GradingResultId"].ToString());
obj.PreviousCommodityGradeId = new Guid(reader["PrevioudCommodityGradeId"].ToString());
if (reader["ExpectedCommodityGradeId"] != DBNull.Value)
{
obj.ExpectedCommodityGradeId = new Guid(reader["ExpectedCommodityGradeId"].ToString());
}
if (reader["DateTimeRequested"] != DBNull.Value)
{
obj.DateTimeRecived = Convert.ToDateTime(reader["DateTimeRequested"].ToString());
}
obj.Remark = reader["Remark"].ToString();
if (reader["Status"] != DBNull.Value)
{
obj.Status = Convert.ToInt32(reader["Status"].ToString());
}
if (reader["CreatedBy"] != DBNull.Value)
{
try
{
obj.CreatedBy = new Guid(reader["CreatedBy"].ToString());
}
catch
{
}
}
if (reader["CreatedTimestamp"] != DBNull.Value)
{
try
{
obj.CreatedTimestamp = DateTime.Parse(reader["CreatedTimestamp"].ToString());
}
catch
{
}
}
if (reader["LastModifiedBy"] != DBNull.Value)
{
try
{
obj.LastModifiedBy = new Guid(reader["LastModifiedBy"].ToString());
}
catch
{
}
}
if (reader["LastModifiedTimestamp"] != DBNull.Value)
{
try
{
obj.LastModifiedTimestamp = DateTime.Parse(reader["LastModifiedTimestamp"].ToString());
}
catch
{
}
}
return(obj);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
}
