private void LoadData(Guid Id)
{
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
obj = obj.GetById(Id);
if (obj != null)
{
if (obj.Id != null)
{
hfGRNID.Value = obj.Id.ToString();
}
if (obj.GRN_Number != null)
{
this.txtGRNNo.Text = obj.GRN_Number;
}
if (obj.DateRequested != null)
{
this.txtDateRequested.Text = obj.DateRequested.ToString();
}
if (obj.Remark != null)
{
this.txtRemark.Text = obj.Remark;
}
hfTrackingNo.Value = obj.TrackingNo;
this.cboStatus.SelectedValue = ((int)obj.Status).ToString();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
obj.Id = new Guid(this.hfGRNID.Value.ToString());
obj.DateRequested = DateTime.Parse(this.txtDateRequested.Text);
obj.Remark = this.txtRemark.Text;
obj.Status = (RequestforApprovedGRNCancelationStatus)int.Parse((this.cboStatus.SelectedValue.ToString()));
try
{
if (obj.Update() == true)
{
this.lblMessage.Text = "Update sucessfull.";
return;
}
else
{
this.lblMessage.Text = "Unable to Update Data.";
return;
}
}
catch
{
this.lblMessage.Text = " An Error has occured please try again";
return;
}
}
public bool CancelGRNCancellationRequest(string TrackingNo)
{
bool isSaved = false;
Utility.LogException(new Exception(TrackingNo));
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
isSaved = obj.CancelGRNCancellationRequest(TrackingNo);
return(isSaved);
}
public static bool save(SqlTransaction tran, RequestforApprovedGRNCancelationBLL obj)
{
try
{
int AffectedRows = 0;
string strSql = "spInsertRequestApprovedGRNCancelation";
SqlParameter[] arPar = new SqlParameter[8];
arPar[0] = new SqlParameter("@GRNId", SqlDbType.UniqueIdentifier);
arPar[0].Value = obj.GRNId;
arPar[1] = new SqlParameter("@RequestedBy", SqlDbType.UniqueIdentifier);
arPar[1].Value = obj.RequestedBy;
arPar[2] = new SqlParameter("@DateRequested", SqlDbType.DateTime);
arPar[2].Value = obj.DateRequested;
arPar[3] = new SqlParameter("@Remark", SqlDbType.Text);
arPar[3].Value = obj.Remark;
arPar[4] = new SqlParameter("@Status", SqlDbType.Int);
arPar[4].Value = (int)obj.Status;
arPar[5] = new SqlParameter("@TrackingNo", SqlDbType.NVarChar, 50);
arPar[5].Value = obj.TrackingNo;
arPar[6] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
arPar[6].Value = UserBLL.GetCurrentUser();
arPar[7] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
arPar[7].Value = obj.Id;
AffectedRows = SqlHelper.ExecuteNonQuery(tran, strSql, arPar);
if (AffectedRows == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception("Unable to Insert Data ", ex);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
bool isSaved = false;
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
obj.GRNId = new Guid(this.hfGRNID.Value.ToString());
obj.RequestedBy = UserBLL.GetCurrentUser();
obj.DateRequested = DateTime.Parse(this.txtDateRequested.Text);
obj.Remark = this.txtRemark.Text;
obj.Status = RequestforApprovedGRNCancelationStatus.New;
isSaved = obj.Add();
if (isSaved == true)
{
this.lblMessage.Text = "Data Added Successfully.";
this.btnAdd.Enabled = false;
}
else
{
this.lblMessage.Text = "Data Can't be Added.please check the data and try again";
return;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (list != null)
{
list.Clear();
}
string GRNNo = string.Empty;
string TrackingNo = string.Empty;
Nullable <DateTime> from = null;
Nullable <DateTime> to = null;
Nullable <RequestforEditGRNStatus> status = null;
GRNNo = this.txtGRN.Text;
TrackingNo = this.txtTrackingNo.Text;
try
{
status = (RequestforEditGRNStatus)int.Parse(this.cboStatus.SelectedValue);
}
catch
{
status = null;
}
try
{
from = DateTime.Parse(this.txtFrom.Text);
}
catch
{
from = null;
}
try
{
to = DateTime.Parse(this.txtTo.Text);
}
catch
{
to = null;
}
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
try
{
list = obj.Search(GRNNo, TrackingNo, status, from, to);
if (list != null)
{
if (list.Count <= 0)
{
this.lblMessage.Text = "No recoreds Found";
this.gvGRNEditRequest.DataSource = list;
this.gvGRNEditRequest.DataBind();
return;
}
else
{
this.gvGRNEditRequest.DataSource = list;
this.gvGRNEditRequest.DataBind();
}
}
else
{
this.lblMessage.Text = "No recoreds Found";
this.gvGRNEditRequest.DataSource = list;
this.gvGRNEditRequest.DataBind();
return;
}
}
catch (Exception ex)
{
this.lblMessage.Text = ex.Message;
}
}
public static RequestforApprovedGRNCancelationBLL GetByTrackingNo(string TrackingNo)
{
string strSql = "spGetRequestApprovedGRNCancelationByTrackingNo";
SqlDataReader reader = null;
SqlParameter[] arPar = new SqlParameter[1];
arPar[0] = new SqlParameter("@TrackingNo", SqlDbType.VarChar, 50);
arPar[0].Value = TrackingNo;
SqlConnection conn = null;
try
{
conn = Connection.getConnection();
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
while (reader.Read())
{
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
if (reader["Id"] != DBNull.Value)
{
obj.Id = new Guid(reader["Id"].ToString());
}
if (reader["GRNId"] != DBNull.Value)
{
obj.GRNId = new Guid(reader["GRNId"].ToString());
}
if (reader["RequestedBy"] != DBNull.Value)
{
obj.RequestedBy = new Guid(reader["RequestedBy"].ToString());
}
if (reader["DateRequested"] != DBNull.Value)
{
obj.DateRequested = DateTime.Parse((reader["DateRequested"].ToString()));
}
obj.Remark = reader["Remark"].ToString();
if (reader["Status"] != DBNull.Value)
{
obj.Status = (RequestforApprovedGRNCancelationStatus)(int.Parse(reader["Status"].ToString()));
}
obj.TrackingNo = reader["Remark"].ToString();
if (reader["TrackingNo"] != DBNull.Value)
{
obj.TrackingNo = reader["TrackingNo"].ToString();
}
if (reader["GRN_Number"] != DBNull.Value)
{
obj.GRN_Number = reader["GRN_Number"].ToString();
}
return(obj);
}
return(null);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (reader != null)
{
reader.Dispose();
}
}
}
private static List <RequestforApprovedGRNCancelationBLL> SearchHelper(string strSql)
{
List <RequestforApprovedGRNCancelationBLL> list;
SqlDataReader reader;
SqlConnection conn = Connection.getConnection();
if (conn == null || conn.State != ConnectionState.Open)
{
throw new Exception("Invalid database connection.");
}
reader = SqlHelper.ExecuteReader(conn, CommandType.Text, strSql);
if (reader.HasRows)
{
list = new List <RequestforApprovedGRNCancelationBLL>();
while (reader.Read())
{
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
if (reader["Id"] != DBNull.Value)
{
obj.Id = new Guid(reader["Id"].ToString());
}
if (reader["GRNId"] != DBNull.Value)
{
obj.GRNId = new Guid(reader["GRNId"].ToString());
}
if (reader["RequestedBy"] != DBNull.Value)
{
obj.RequestedBy = new Guid(reader["RequestedBy"].ToString());
}
if (reader["DateRequested"] != DBNull.Value)
{
obj.DateRequested = DateTime.Parse((reader["DateRequested"].ToString()));
}
obj.Remark = reader["Remark"].ToString();
if (reader["Status"] != DBNull.Value)
{
obj.Status = (RequestforApprovedGRNCancelationStatus)(int.Parse(reader["Status"].ToString()));
}
obj.TrackingNo = reader["Remark"].ToString();
if (reader["TrackingNo"] != DBNull.Value)
{
obj.TrackingNo = reader["TrackingNo"].ToString();
}
if (reader["GRN_Number"] != DBNull.Value)
{
obj.GRN_Number = reader["GRN_Number"].ToString();
}
list.Add(obj);
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(list);
}
else
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(null);
}
}
