private void GridDataBind()
{
try
{
ApplicationResult objResult = new ApplicationResult();
StatusBL objStatusBl = new StatusBL();
objResult = objStatusBl.Status_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
gvStatus.DataSource = objResult.resultDT;
gvStatus.DataBind();
PanelGrid_VisibilityMode(1);
}
else
{
PanelGrid_VisibilityMode(2);
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
StatusBL objBL_Status = new StatusBL();
StatusBE objStatus = new StatusBE();
objStatus.IdStatus = IdStatus;
objStatus.NameStatus = txtDescripcion.Text;
objStatus.FlagState = true;
objStatus.Login = Parametros.strUsuarioLogin;
objStatus.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objStatus.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Status.Inserta(objStatus);
}
else
{
objBL_Status.Actualiza(objStatus);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void tlbMenu_DeleteClick()
{
try
{
Cursor = Cursors.WaitCursor;
if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!ValidarIngreso())
{
StatusBE objE_Status = new StatusBE();
objE_Status.IdStatus = int.Parse(gvStatus.GetFocusedRowCellValue("IdStatus").ToString());
objE_Status.Login = Parametros.strUsuarioLogin;
objE_Status.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Status.IdCompany = Parametros.intEmpresaId;
StatusBL objBL_Status = new StatusBL();
objBL_Status.Elimina(objE_Status);
XtraMessageBox.Show("The record was successfully deleted.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Cargar();
}
}
Cursor = Cursors.Default;
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PopulateGridView()
{
DataTable dt = new DataTable();
StatusBL statusBLOBj = new StatusBL();
dt = statusBLOBj.GetExistingdStatusBL();
statusDataGridView.DataSource = dt;
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
StatusBO objStatusBo = new StatusBO();
ApplicationResult objResults = new ApplicationResult();
StatusBL objStatusBl = new StatusBL();
Controls objControls = new Controls();
objStatusBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objStatusBo.StatusName = txtStatusName.Text;
objStatusBo.Discription = txtStatusDesc.Text;
objStatusBo.LastModificationDate = DateTime.UtcNow.AddHours(5.5).ToString();
objStatusBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
if (ViewState["Mode"].ToString() == "Save")
{
objResults = objStatusBl.Status_Insert(objStatusBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Status Created Successfully.');</script>");
GridDataBind();
PanelGrid_VisibilityMode(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Status Name " + txtStatusName.Text + " Already Exists');</script>");
}
}
else
{
objStatusBo.StatusMasterID = Convert.ToInt32(ViewState["StatusMasterID"].ToString());
objResults = objStatusBl.Status_Update(objStatusBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Status updated successfully.');</script>");
GridDataBind();
ClearAll();
//objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ViewState["Mode"] = "Save";
btnSave.Text = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Status Name " + txtStatusName.Text + " Already Exists');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void gvStatus_RowCommand(object sender, GridViewCommandEventArgs e)
{
StatusBL objStatusBl = new StatusBL();
try
{
ViewState["StatusMasterID"] = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName.ToString() == "Edit1")
{
ApplicationResult objResultsEdit = new ApplicationResult();
objResultsEdit = objStatusBl.Status_Select(Convert.ToInt32(ViewState["StatusMasterID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResultsEdit != null)
{
if (objResultsEdit.resultDT.Rows.Count > 0)
{
txtStatusName.Text = objResultsEdit.resultDT.Rows[0][StatusBO.STATUS_STATUSNAME].ToString();
txtStatusDesc.Text = objResultsEdit.resultDT.Rows[0][StatusBO.STATUS_DISCRIPTION].ToString();
ViewState["Mode"] = "Edit1";
PanelGrid_VisibilityMode(2);
}
}
}
if (e.CommandName.ToString() == "Delete1")
{
Controls objControls = new Controls();
objControls.EnableControls(Master.FindControl("ContentPlaceHolder1"));
ApplicationResult objDelete = new ApplicationResult();
objDelete = objStatusBl.Validate_Status_Delete(Convert.ToInt32(ViewState["StatusMasterID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objDelete != null)
{
ApplicationResult objResultsDelete = new ApplicationResult();
objResultsDelete = objStatusBl.Status_Delete(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Status deleted successfully.');</script>");
GridDataBind();
PanelGrid_VisibilityMode(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('There are Student(s) associated with this Status. To delete this Status you need to delete Student(s) first');</script>");
}
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
public List <HoldCargoViewModel> Match(List <HoldCargo> _holdcargo)
{
List <HoldCargoViewModel> _results = new List <HoldCargoViewModel>();
PackageNumberBL _packageNumberService = new PackageNumberBL();
StatusBL status = new StatusBL();
ReasonBL reason = new ReasonBL();
UserRoleBL user = new UserRoleBL();
ShipmentBL shipmentService = new ShipmentBL();
List <Shipment> shipList = shipmentService.GetAll();
UserStore _userService = new UserStore();
foreach (HoldCargo holdCargo in _holdcargo)
{
HoldCargoViewModel model = new HoldCargoViewModel();
//string _airwaybill = _packageNumberService.GetAll().Find(x => x.PackageNo == holdCargo.Cargo).Shipment.AirwayBillNo;
HoldCargoViewModel isExist = _results.Find(x => x.AirwayBillNo == holdCargo.AirwayBillNo);
if (isExist != null)
{
}
else
{
model.Date = holdCargo.HoldCargoDate;
model.AirwayBillNo = holdCargo.AirwayBillNo;
Shipment ship = shipList.Find(x => x.AirwayBillNo == holdCargo.AirwayBillNo);
if (ship != null)
{
model.Shipper = ship.Shipper.FullName;
model.Consignee = ship.Consignee.FullName;
model.Address = ship.Consignee.Address1;
model.PaymentMode = ship.PaymentMode.PaymentModeName;
model.ServiceMode = ship.ServiceMode.ServiceModeName;
model.Status = status.GetById(holdCargo.StatusID).StatusName; // status.GetAll().Find(x => x.StatusID == holdCargo.StatusID).StatusName;
model.Reason = reason.GetById(holdCargo.ReasonID).ReasonName; // .Find(x => x.ReasonID == holdCargo.ReasonID).ReasonName;
model.EndorseBy = holdCargo.Endorsedby;
//model.ScannedBy = user.GetActiveRoles().Find(x => x.RoleId == AppUser.User.UserId).RoleName;
//model.ScannedBy = holdCargo.User.Employee.FullName;
model.ScannedBy = "N/A";
string employee = _userService.FindById(holdCargo.CreatedBy).Employee.FullName;
if (employee != "")
{
model.ScannedBy = employee;
}
//model.PreparedBy = user.GetAllUsers().Find(x => x.UserId == shi)
model.Aging = Math.Round((DateTime.Now - holdCargo.HoldCargoDate).TotalDays, 2);
model.Branch = holdCargo.User.Employee.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeName;
_results.Add(model);
}
}
}
return(_results);
}
void ExportarExcel(string filename)
{
Excel._Application xlApp;
Excel._Workbook xlLibro;
Excel._Worksheet xlHoja;
Excel.Sheets xlHojas;
xlApp = new Excel.Application();
filename = Path.Combine(Directory.GetCurrentDirectory(), "Excel\\Status.xlsx");
xlLibro = xlApp.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlHojas = xlLibro.Sheets;
xlHoja = (Excel._Worksheet)xlHojas[1];
Cursor.Current = Cursors.WaitCursor;
try
{
int Row = 6;
int Secuencia = 1;
List <StatusBE> lstStatus = null;
lstStatus = new StatusBL().ListaTodosActivo(Parametros.intEmpresaId);
if (lstStatus.Count > 0)
{
xlHoja.Shapes.AddPicture(Path.Combine(Directory.GetCurrentDirectory(), "Logo.jpg"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 1, 1, 100, 60);
foreach (var item in lstStatus)
{
xlHoja.Cells[Row, 1] = item.IdStatus;
xlHoja.Cells[Row, 2] = item.NameStatus;
Row = Row + 1;
Secuencia = Secuencia + 1;
}
}
xlLibro.SaveAs("C:\\Excel\\Status.xlsx", Excel.XlFileFormat.xlWorkbookDefault, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlLibro.Close(true, Missing.Value, Missing.Value);
xlApp.Quit();
Cursor.Current = Cursors.Default;
BSUtils.OpenExcel("C:\\Excel\\Status.xlsx");
//XtraMessageBox.Show("It was imported correctly \n The file was generated C:\\Excel\\Status.xlsx", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
xlLibro.Close(false, Missing.Value, Missing.Value);
xlApp.Quit();
Cursor.Current = Cursors.Default;
MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public static ExpenditureDTO DALtoDTO(Expenditure expenditure)
{
ExpenditureDTO expenditureNew = new ExpenditureDTO()
{
Id = expenditure.Id,
Amount = expenditure.Amount,
Date = (DateTime)expenditure.Date,
Purpose = expenditure.Purpose,
Receives = expenditure.Receives,
NameStatus = expenditure.NameStatus,
Way_of_payment = expenditure.Way_of_payment,
Status = expenditure.NameStatus != null?StatusBL.GetByName(expenditure.NameStatus) : null
};
return(expenditureNew);
}
public void getStatusName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
StatusBL objStatusBl = new StatusBL();
objResult = objStatusBl.Status_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlStatus, "StatusName", "StatusMasterID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlStatus.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", ""));
}
}
private void BindgvStatus()
{
try
{
StatusBL objReceptionBl = new StatusBL();
var objResult = objReceptionBl.Status_SelectAll();
if (objResult != null)
{
gvStatus.DataSource = objResult.ResultDt;
gvStatus.DataBind();
PanelVisibilityMode(true, false);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void frmManStatusEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Status - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Status - Update";
StatusBE objE_Status = null;
objE_Status = new StatusBL().Selecciona(IdStatus);
if (objE_Status != null)
{
txtDescripcion.Text = objE_Status.NameStatus.Trim();
}
}
txtDescripcion.Select();
}
public bool ValidateName()
{
StatusBL objStatusBl = new StatusBL();
ApplicationResult objResults = new ApplicationResult();
if (ViewState["Mode"].ToString() == "Save")
{
objResults = objStatusBl.Status_ValidateName(txtStatusName.Text, -1, Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
}
else
{
objResults = objStatusBl.Status_ValidateName(txtStatusName.Text, Convert.ToInt32(ViewState["StatusMasterID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
}
if (objResults.resultDT.Rows.Count > 0)
{
return(true);
}
return(false);
}
protected void gvStatus_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
StatusBL objStatusBL = new StatusBL();
if (e.CommandName == "Edit1")
{
ViewState["Mode"] = "Edit";
ViewState["ID"] = e.CommandArgument.ToString();
var objResult = objStatusBL.Status_Select(Convert.ToInt32(ViewState["ID"].ToString()));
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
txtName.Text = objResult.ResultDt.Rows[0][StatusBo.STATUS_NAME].ToString();
txtPLCValue.Text = objResult.ResultDt.Rows[0][StatusBo.STATUS_PLCVALUE].ToString();
PanelVisibilityMode(false, true);
}
}
}
else if (e.CommandName == "Delete1")
{
var objResult = objStatusBL.Status_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), System.DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>");
PanelVisibilityMode(true, false);
BindgvStatus();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this Reception because it is in used.');</script>");
}
}
}
catch (Exception ex)
{
log.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>");
}
}
private void BindStatus()
{
try
{
StatusBL objStatusBL = new StatusBL();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
objResults = objStatusBL.Status_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResults != null)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlStatus, "StatusName", "StatusMasterID");
if (objResults.resultDT.Rows.Count > 0)
{
}
ddlStatus.Items.Insert(0, new ListItem("-Select-", ""));
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
private void updateButton_Click(object sender, EventArgs e)
{
Status aStatus = new Status();
aStatus.StatusNo = textBox1.Text;
aStatus.StatusPosition = statusPositionTextBox.Text;
aStatus.Statusdetails = richTextBox.Text;
StatusBL statusBLOBj = new StatusBL();
bool result = statusBLOBj.UpdateNewStatusBL(aStatus);
if (result)
{
MessageBox.Show("Successfully Updated", "Done", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.PopulateGridView();
IntitialButtonMood();
CleanTextBar();
}
else
{
MessageBox.Show("Something went Wrong!", "Aleart", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
StatusBo objStatusBo = new StatusBo();
StatusBL objStatusBl = new StatusBL();
objStatusBo.Name = txtName.Text.Trim();
objStatusBo.PLCValue = Convert.ToInt32(txtPLCValue.Text);
if (ViewState["Mode"].ToString() == "Save")
{
objStatusBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objStatusBo.CreatedDate = DateTime.UtcNow.AddHours(5.5);
var objResult = objStatusBl.Status_Insert(objStatusBo);
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString());
if (intStatus == 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtName.Text + " is already exist.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
BindgvStatus();
PanelVisibilityMode(true, false);
}
}
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objStatusBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objStatusBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
objStatusBo.Id = Convert.ToInt32(ViewState["ID"].ToString());
var objResult = objStatusBl.Status_Update(objStatusBo);
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString());
if (intStatus == 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtName.Text + " is already exist.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
BindgvStatus();
PanelVisibilityMode(true, false);
}
}
}
}
}
catch (Exception ex)
{
log.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>");
}
}
public List <StatusDTO> get()
{
return(StatusBL.GetList());
}
