public bool DeleteModuleMasterInfo(int moduleID, string reason, int deletedBy)
{
bool result = false;
try
{
Tbl_MP_Master_Module editItem = _dbContext.Tbl_MP_Master_Module.Where(x => x.pk_ModuleId == moduleID).FirstOrDefault();
editItem.DeleteDatetime = AppCommon.GetServerDateTime();
// editItem.DeletedBy = CURR_USER.EmployeeID;
editItem.DeletedBy = deletedBy;
editItem.IsActive = false;
editItem.DeleteRemarks = reason;
_dbContext.SaveChanges();
string strQuery = string.Format("UPDATE Tbl_MP_Master_Module_Forms SET DeletedBy={0}, DeleteDatetime='{1}', DeleteRemarks='{2}',IsActive=0 WHERE FK_ModuleID={3}",
deletedBy, AppCommon.GetServerDateTime().ToString("yyyy-MM-dd hh:ss"), reason, moduleID);
int cnt = _dbContext.Database.ExecuteSqlCommand(strQuery);
result = true;
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.Message);
MessageBox.Show(errMessage, "ServiceModules::DeleteModuleMasterInfo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
private void frmAddEditAppModule_Load(object sender, EventArgs e)
{
try
{
txtDisplayName.Text = txtModuleName.Text = txtSequence.Text = string.Empty;
chkIsActive.Checked = true;
txtSequence.Text = (new ServiceModules()).GetNewModuleSequenceNo().ToString();
this.Text = "Application Module [ADD NEW]";
if (this.ModuleID != 0)
{
Tbl_MP_Master_Module module = (new ServiceModules()).GetModuleDBRecordByID(this.ModuleID);
if (module != null)
{
txtModuleName.Text = module.ModuleName;
txtDisplayName.Text = module.DisplayName;
txtSequence.Text = module.SequenceNo.ToString();
chkIsActive.Checked = module.IsActive;
}
this.Text = "Application Module [EDIT]";
}
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.Message);
MessageBox.Show(errMessage, "frmAddEditAppModule::frmAddEditAppModule_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditFormPermission_Load(object sender, EventArgs e)
{
try
{
SetPermissionButtonsTag();
if (RoleFormID != 0)
{
TBL_MP_Master_RoleForm model = (new ServiceRoles()).GetRoleModuleFormDBRecordByID(this.RoleFormID);
if (model != null)
{
Tbl_MP_Master_Module dbModule = (new ServiceModules()).GetModuleDBRecordByID((int)model.FK_ModuleId);
if (dbModule != null)
{
lblModuleName.Text = dbModule.DisplayName.ToUpper();
}
Tbl_MP_Master_Module_Forms dbModuleForm = (new ServiceModules()).GetModuleFormDBRecordByID((int)model.FK_FormId);
if (dbModuleForm != null)
{
lblFormName.Text = dbModuleForm.DisplayName;
}
btnCanAddNewRecord.Checked = model.CanAddNew;
PermissionsButton_Click(btnCanAddNewRecord, new EventArgs());
btnCanApproveRecord.Checked = model.CanApprove;
PermissionsButton_Click(btnCanApproveRecord, new EventArgs());
btnCanAuthorizeRecord.Checked = model.CanAuthorize;
PermissionsButton_Click(btnCanAuthorizeRecord, new EventArgs());
btnCanCheckRecord.Checked = model.CanCheck;
PermissionsButton_Click(btnCanCheckRecord, new EventArgs());
btnCanDeleteRecord.Checked = model.CanDelete;
PermissionsButton_Click(btnCanDeleteRecord, new EventArgs());
btnCanModifyRecord.Checked = model.CanModify;
PermissionsButton_Click(btnCanModifyRecord, new EventArgs());
btnCanPrintRecord.Checked = model.CanPrint;
PermissionsButton_Click(btnCanPrintRecord, new EventArgs());
btnCanViewRecord.Checked = model.CanView;
PermissionsButton_Click(btnCanViewRecord, new EventArgs());
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditFormPermission::frmAddEditFormPermission_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridModules_RowEnter(object sender, DataGridViewCellEventArgs e)
{
try
{
headerGroupDeleteModule.ValuesPrimary.Heading = string.Empty;
txtDeleteModuleInfo.Text = string.Empty;
if (e.RowIndex >= 0)
{
SelectedModuleID = (int)gridModules.Rows[e.RowIndex].Cells["ID"].Value;
PopulateForms();
}
bool isactive = (bool)gridModules.Rows[e.RowIndex].Cells["IsActive"].Value;
if (isactive)
{
btnRestoreModule.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
btnEditModule.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
btnDeleteModule.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
btnAddNewForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
btnEditForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
btnDeleteForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
btnRestoreForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
}
else
{
btnRestoreModule.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.True;
btnEditModule.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
btnDeleteModule.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
btnAddNewForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
btnEditForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
btnDeleteForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
btnRestoreForm.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False;
}
Tbl_MP_Master_Module dbModule = (new ServiceModules()).GetModuleDBRecordByID(this.SelectedModuleID);
if (dbModule != null)
{
if (dbModule.DeletedBy != null)
{
string empName = ServiceEmployee.GetEmployeeNameByID((int)dbModule.DeletedBy);
headerGroupDeleteModule.ValuesPrimary.Heading = string.Format("Deleted by {0} dt. {1}", empName, dbModule.DeleteDatetime.Value.ToString("dd MMM yy hh:mmtt"));
}
txtDeleteModuleInfo.Text = dbModule.DeleteRemarks;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "pageModules::gridModules_RowEnter", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
Tbl_MP_Master_Module model = null;
try
{
errorProvider1.Clear();
if (this.ValidateChildren())
{
if (this.ModuleID == 0)
{
model = new Tbl_MP_Master_Module()
{
ModuleName = txtModuleName.Text.Trim(),
DisplayName = txtDisplayName.Text.Trim(),
SequenceNo = int.Parse(txtSequence.Text.Trim()),
IsActive = chkIsActive.Checked
};
this.ModuleID = (new ServiceModules()).AddNewModule(model);
if (this.ModuleID != 0)
{
this.DialogResult = DialogResult.OK;
}
}
else
{
model = (new ServiceModules()).GetModuleDBRecordByID(this.ModuleID);
if (model != null)
{
model.ModuleName = txtModuleName.Text.Trim();
model.DisplayName = txtDisplayName.Text.Trim();
model.SequenceNo = int.Parse(txtSequence.Text.Trim());
model.IsActive = chkIsActive.Checked;
bool res = (new ServiceModules()).UpdateModule(model);
if (res)
{
this.DialogResult = DialogResult.OK;
}
}
}
}
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.Message);
MessageBox.Show(errMessage, "frmAddEditAppModule::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
public Tbl_MP_Master_Module GetModuleDBRecordByID(int moduleID)
{
Tbl_MP_Master_Module module = null;
try
{
module = _dbContext.Tbl_MP_Master_Module.Where(x => x.pk_ModuleId == moduleID).FirstOrDefault();
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.Message);
MessageBox.Show(errMessage, "ServiceModules::GetModuleDBRecordByID", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(module);
}
public bool UndeleteModuleMasterInfo(int moduleID, string reason)
{
bool result = false;
try
{
Tbl_MP_Master_Module editItem = _dbContext.Tbl_MP_Master_Module.Where(x => x.pk_ModuleId == moduleID).FirstOrDefault();
editItem.DeleteDatetime = null;
editItem.DeletedBy = null;
editItem.IsActive = true;
editItem.DeleteRemarks = reason;
_dbContext.SaveChanges();
result = true;
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.Message);
MessageBox.Show(errMessage, "ServiceModules::UndeleteModuleMasterInfo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
public int AddNewModule(Tbl_MP_Master_Module model)
{
int newID = 0;
try
{
Tbl_MP_Master_Module newModule = new Tbl_MP_Master_Module();
newModule.ModuleName = model.ModuleName;
newModule.DisplayName = model.DisplayName;
newModule.IsActive = model.IsActive;
newModule.SequenceNo = model.SequenceNo;
_dbContext.Tbl_MP_Master_Module.Add(newModule);
_dbContext.SaveChanges();
newID = newModule.pk_ModuleId;
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.InnerException.Message);
MessageBox.Show(errMessage, "ServiceModules::AddNewModule", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(newID);
}
public bool UpdateModule(Tbl_MP_Master_Module model)
{
bool result = false;
try
{
Tbl_MP_Master_Module newModule = _dbContext.Tbl_MP_Master_Module.Where(x => x.pk_ModuleId == model.pk_ModuleId).FirstOrDefault();
if (newModule != null)
{
newModule.ModuleName = model.ModuleName;
newModule.DisplayName = model.DisplayName;
newModule.IsActive = model.IsActive;
newModule.SequenceNo = model.SequenceNo;
_dbContext.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
string errMessage = string.Format("{0}\n{1}", ex.Message, ex.InnerException.Message);
MessageBox.Show(errMessage, "ServiceModules::UpdateModule", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result);
}
private void PopulateDescription()
{
try
{
switch (this.ENTITY)
{
case APP_ENTITIES.INVENTORY_ITEM:
TBL_MP_Master_Item dbItem = (new ServiceInventoryItems()).GetItemDBRecord(this.ENTITY_ID);
if (dbItem != null)
{
txtDescription.Text = string.Format("{0}\n{1}\nCODE: {2}", dbItem.Item_Name, dbItem.Long_Description, dbItem.ItemCode);
}
break;
case APP_ENTITIES.PARTIES:
Tbl_MP_Master_Party dbParty = (new ServiceParties()).GetPartyByPartyID(this.ENTITY_ID);
if (dbParty != null)
{
txtDescription.Text = string.Format("{0} ({1})\n{2}", dbParty.PartyName, dbParty.PartyType, dbParty.PartyCode);
}
break;
case APP_ENTITIES.INVENTORY_ITEM_ATTACHMENT:
TBL_MP_Master_Item_Attachments dbItemAttachment = (new ServiceInventoryItems()).GetInventoryItemAttachmentDBRecord(this.ENTITY_ID);
if (dbItemAttachment != null)
{
txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbItemAttachment.Title.ToUpper(), dbItemAttachment.TBL_MP_Master_Item.Item_Name, dbItemAttachment.TBL_MP_Master_Item.Long_Description);
}
break;
case APP_ENTITIES.APPLICATION_MODULES:
Tbl_MP_Master_Module dbModule = (new ServiceModules()).GetModuleDBRecordByID(this.ENTITY_ID);
if (dbModule != null)
{
txtDescription.Text = string.Format("NAME: {0}\nDISPLAY: {1}", dbModule.ModuleName, dbModule.DisplayName);
}
break;
case APP_ENTITIES.MODULES_FORMS:
Tbl_MP_Master_Module_Forms dbForm = (new ServiceModules()).GetModuleFormDBRecordByID(this.ENTITY_ID);
if (dbForm != null)
{
txtDescription.Text = string.Format("NAME: {0}\nDISPLAY: {1}", dbForm.FormName, dbForm.DisplayName);
}
break;
case APP_ENTITIES.ROLES:
TBL_MP_Master_Role dbRole = (new ServiceRoles()).GetRoleDBRecordByID(this.ENTITY_ID);
if (dbRole != null)
{
txtDescription.Text = string.Format("ROLE NAME: {0}\nROLE NO.: {1}", dbRole.RoleName, dbRole.RoleNo);
}
break;
case APP_ENTITIES.SALES_LEAD_ATTACHMENT:
TBL_MP_CRM_SM_SalesLead_Attachment dbLeadAttachment = (new ServiceSalesLead()).GetSalesLeadAttachmentDBRecord(this.ENTITY_ID);
if (dbLeadAttachment != null)
{
txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbLeadAttachment.Title.ToUpper(), dbLeadAttachment.TBL_MP_CRM_SM_SalesLead.LeadNo, dbLeadAttachment.TBL_MP_Master_UserList.Description1);
}
break;
case APP_ENTITIES.SALES_ENQUIRY_ATTACHMENT:
TBL_MP_CRM_SalesEnquiry_Attachments dbEnquiryAttachment = (new ServiceSalesEnquiry()).GetSalesEnquiryAttachmentDBRecord(this.ENTITY_ID);
if (dbEnquiryAttachment != null)
{
txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbEnquiryAttachment.Title.ToUpper(), dbEnquiryAttachment.TBL_MP_CRM_SalesEnquiry.SalesEnquiry_No, dbEnquiryAttachment.TBL_MP_Master_UserList.Description1);
}
break;
case APP_ENTITIES.SALES_QUOTATION_ATTACHMENT:
TBL_MP_CRM_SalesQuotation_Attachments dbQuoteAttachment = (new ServiceSalesQuotation()).GetSalesQuotationAttachmentDBRecord(this.ENTITY_ID);
if (dbQuoteAttachment != null)
{
txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbQuoteAttachment.Title.ToUpper(), dbQuoteAttachment.TBL_MP_CRM_SalesQuotation.Quotation_No, dbQuoteAttachment.TBL_MP_Master_UserList.Description1);
}
break;
case APP_ENTITIES.SALES_ORDER_ATTACHMENT:
TBL_MP_CRM_SalesOrder_Attachment dbOrderAttachment = (new ServiceSalesOrder()).GetSalesOrderAttachmentDBRecord(this.ENTITY_ID);
if (dbOrderAttachment != null)
{
txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbOrderAttachment.Title.ToUpper(), dbOrderAttachment.TBL_MP_CRM_SalesOrder.SalesOrderNo, dbOrderAttachment.TBL_MP_Master_UserList.Description1);
}
break;
case APP_ENTITIES.EMPLOYEES_ATTACHMENT:
TBL_MP_Master_Employee_Attachment dbEmpAttachment = (new ServiceEmployee()).GetEmployeeAttachmentDBRecord(this.ENTITY_ID);
if (dbEmpAttachment != null)
{
txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbEmpAttachment.Title.ToUpper(), dbEmpAttachment.TBL_MP_Master_Employee.EmployeeCode, dbEmpAttachment.TBL_MP_Master_UserList.Description1);
}
break;
case APP_ENTITIES.CONTACTS:
Tbl_MP_Master_PartyContact_Detail dbContact = (new ServiceContacts()).GetContactID(this.ENTITY_ID);
if (dbContact != null)
{
txtDescription.Text = string.Format("Contact Person Name : {0}\nAddress:{1}\nMobile No:{2}\nAt.Telephone No:{3}\nEmail ID:{4}\n FAX NO:{5}", dbContact.ContactPersoneName, dbContact.Address, dbContact.MobileNo, dbContact.TelephoneNo, dbContact.EmailID, dbContact.FaxNo);
}
break;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmDelete::PopulateDescription", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <SelectListItem> GetFormsGridforRole(int roleID)
{
List <SelectListItem> lstData = new List <SelectListItem>();
try
{
List <TBL_MP_Master_RoleForm> lstRoleForm = (from xx in _dbContext.TBL_MP_Master_RoleForm where xx.FK_RoleID == roleID select xx).ToList();
foreach (TBL_MP_Master_RoleForm dbItem in lstRoleForm)
{
string strDescription = string.Empty;
Tbl_MP_Master_Module dbModule = (new ServiceModules()).GetModuleDBRecordByID((int)dbItem.FK_ModuleId);
if (dbModule != null)
{
strDescription = dbModule.DisplayName.ToUpper();
}
Tbl_MP_Master_Module_Forms dbModuleForm = (new ServiceModules()).GetModuleFormDBRecordByID((int)dbItem.FK_FormId);
if (dbModuleForm != null)
{
strDescription = string.Format("{0} ({1})\n", strDescription, dbModuleForm.DisplayName);
}
if (dbItem.CanAddNew)
{
strDescription += "ADD ";
}
if (dbItem.CanApprove)
{
strDescription += "APPROVE ";
}
if (dbItem.CanAuthorize)
{
strDescription += "AUTHORIZE ";
}
if (dbItem.CanCheck)
{
strDescription += "CHECK ";
}
if (dbItem.CanDelete)
{
strDescription += "DELETE ";
}
if (dbItem.CanModify)
{
strDescription += "MODIFY ";
}
if (dbItem.CanPrepare)
{
strDescription += "PREPARE ";
}
if (dbItem.CanPrint)
{
strDescription += "PRINT ";
}
if (dbItem.CanView)
{
strDescription += "VIEW ";
}
SelectListItem item = new SelectListItem()
{
ID = dbItem.PK_RoleFormID
};
item.Description = strDescription;
lstData.Add(item);
}
}
catch (Exception ex)
{
string strError = ex.Message;
if (ex.InnerException != null)
{
strError += "\n" + ex.InnerException.Message;
}
MessageBox.Show(strError, "ServiceRoles::GetFormsGridForRoleModule", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(lstData);
}
