protected void btnSubmitStatus_Click(object sender, EventArgs e)
{
try
{
_statusbo = new statusBO();
_statusbo.closureFlag = 0;
_statusbo.wmsId = Convert.ToInt32(lblWmsIdValue.Text);
_statusbo.status = Convert.ToInt32(ddlChangeStatus.SelectedValue);
_statusbo.assignedTo = 0;
if (ddlAssignTo.SelectedValue != "" && ddlAssignTo.SelectedValue != null)
{
_statusbo.assignedTo = Convert.ToInt32(ddlAssignTo.SelectedValue);
}
_statusbo.comment = txtAdminComment.Text;
if (ddlChangeStatus.SelectedItem.Text == "Close")
{
_statusbo.closureFlag = 1;
_statusbo.materialsUsed = txtMaterialsUsed.Text;
_statusbo.teamMembers = txtTeamMembers.Text;
_statusbo.timeIn = Convert.ToDateTime(txtIntime.Text.ToString());
_statusbo.timeOut = Convert.ToDateTime(txtOutTime.Text.ToString());
}
_rqstbl = new requestBL();
var tranid = _rqstbl.changestatus(_statusbo);
if (!(tranid.Equals(0)))
{
lblMessage.Text = "Status updated succesfully";
lblMessage.Visible = true;
FillStatusDropDown(tranid);
FillRequestDetails(tranid);
txtAdminComment.Text = "";
}
else
{
lblMessage.Text = "Status updation failed. Please try again";
lblMessage.Visible = true;
}
}
catch (Exception ex)
{
throw;
}
}
public int changeStatus(statusBO _statusBO)
{
try
{
var cmd = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
Connection = _sqlcon,
CommandText = "sp_Status_Upd"
};
cmd.Parameters.Add("@WMSID", SqlDbType.VarChar).Value = _statusBO.wmsId;
cmd.Parameters.Add("@StatusID", SqlDbType.Int).Value = _statusBO.status;
cmd.Parameters.Add("@AssignedID", SqlDbType.Int).Value = _statusBO.assignedTo;
cmd.Parameters.Add("@Comment", SqlDbType.VarChar).Value = _statusBO.comment;
cmd.Parameters.Add("@CLOSUREFLAG", SqlDbType.Int).Value = _statusBO.closureFlag;
cmd.Parameters.Add("@MATERIALSUSED", SqlDbType.VarChar).Value = _statusBO.materialsUsed;
cmd.Parameters.Add("@TEAMMEMBERS", SqlDbType.VarChar).Value = _statusBO.teamMembers;
cmd.Parameters.Add("@TIMEIN", SqlDbType.DateTime).Value = _statusBO.timeIn;
cmd.Parameters.Add("@TIMEOUT", SqlDbType.DateTime).Value = _statusBO.timeOut;
//change after login
cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = 2;
// cmd.Parameters.Add("@InsUpd_Flag", SqlDbType.Int).Value = rqstbo.InsUpdFlag;
SqlParameter WMSID_Out = new SqlParameter("@WMSID_Out", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(WMSID_Out);
_sqlcon.Open();
cmd.ExecuteNonQuery();
int result = Convert.ToInt16(WMSID_Out.Value);
return(result);
}
catch (Exception ex)
{
return(0);
}
finally
{
_sqlcon.Close();
}
}
public int changestatus(statusBO statusBO)
{
requestDA objRequestDA = new requestDA();
return(objRequestDA.changeStatus(statusBO));
}
