public void AddInwardDetailsTest() { IGRSS.BusinessLogicLayer.InwardOutward target = new IGRSS.BusinessLogicLayer.InwardOutward(); FormViewParameter Parameter = new FormViewParameter(); IGRSS.DataAccessLayer.InwardOutward.Inward_OutwardRegisterDataTable dt = new IGRSS.DataAccessLayer.InwardOutward.Inward_OutwardRegisterDataTable(); DataRow dr = dt.NewRow(); dr["Inward_outwardId"] = new Guid(); dr["RegisterType"] = "I"; dr["DocumentNo"] = "2221"; dr["InOutDate"] =DateTime.Now; dr["DocType"] = new Guid("f21071c4-076b-4040-bf45-412889457dae"); dr["SentOfficeID"] = new Guid("916fd082-061a-45fb-91a4-33967243b4cf"); dr["ReceivingOfficeID"] =new Guid("916fd082-061a-45fb-91a4-33967243b4cf"); dr["DocumentSentFrom"] = "Chennai"; dr["DocumentSentTo"] ="BANGALORE"; dr["Description"] = "500"; dr["StampValueAffixed"] = 20; dr["DeliveryType"] =new Guid("8d0413b8-75d9-4c46-9b0b-019b4dcb9253"); dr["Remarks"] = "500"; dr["CreatedBy"] ="RAJA"; dt.Rows.Add(dr); Parameter.Values = dt.Rows[0]; Assert.AreEqual(true,target.AddInwardDetails(Parameter), "IGRSS.BusinessLogicLayer.InwardOutward.AddInwardDetails did not return the expect" + "ed value."); }
protected void odsBranch_Updating(object sender, ObjectDataSourceMethodEventArgs e) { FormViewParameter Parameters = new FormViewParameter(); Parameters.Values = (DataRow)e.InputParameters["Values"]; e.InputParameters["Parameter"] = Parameters; e.InputParameters.Remove("Values"); }
protected void odsOfficeCommunicationById_Inserting(object sender, ObjectDataSourceMethodEventArgs e) { FormViewParameter Parameters = new FormViewParameter(); Parameters.Values = (DataRow) e.InputParameters["Values"]; e.InputParameters["Parameter"] = Parameters; e.InputParameters.Remove("Values"); }
protected void OdsQualificationMaster_Inserting(object sender, ObjectDataSourceMethodEventArgs e) { FormViewParameter Parameters = new FormViewParameter(); Parameters.Values = (DataRow) e.InputParameters["Values"]; e.InputParameters["Parameter"] = Parameters; e.InputParameters.Remove("Values"); }
protected void odsInspectionCheckList_Inserting(object sender, ObjectDataSourceMethodEventArgs e) { FormViewParameter Parameters = new FormViewParameter(); Parameters.Values = (DataRow) e.InputParameters["Values"]; e.InputParameters["Parameter"] = Parameters; e.InputParameters.Remove("Values"); }
public bool UpdateValuationForm(FormViewParameter ValFormParameter, DataTable DocDetails) { try { string curUser = Thread.CurrentPrincipal.Identity.Name; ValuationFormRow ValFormrow = (IGRSS.DataAccessLayer.Adjudication.ValuationFormRow)ValFormParameter.Values; Guid ValuationFormId = ValFormrow.OfficeId; IgrssAdapters.ValuationAdapter.UpdateValuationFormByValFormId( ValFormrow.Village_CityName, ValFormrow.TPSchemeNo, ValFormrow.TPSchemeName, ValFormrow.FinalPlotNo, ValFormrow.CitySurveyNo, ValFormrow.RevenueSurveyNo, ValFormrow.Ward_SubWardNo, ValFormrow.NameOfOwner, ValFormrow.AddressOfOwner, ValFormrow.NameOfClaimingParty, ValFormrow.AddressOfClaimingParty, ValFormrow.AreaOfPlot, ValFormrow.AreaOfConstruction, ValFormrow.YearOfConstruction, ValFormrow.NoOfFloors, ValFormrow.TypeOfProperty, ValFormrow.HeightOfCeiling, ValFormrow.TypeOfTiles, ValFormrow.WallFurnishing, ValFormrow.NoOfBathrooms, ValFormrow.BathroomTilesHeight, ValFormrow.NoOfToilets, ValFormrow.ToiletTilesHeight, ValFormrow.Parking, ValFormrow.DescOfProperty, ValFormrow.ShopsOnGroundFloor, ValFormrow.IsPropertyInCommercial, ValFormrow.TypeOfElectricfication, ValFormrow.CompoundWallType, ValFormrow.IsLightsOnCompoundWall, ValFormrow.WaterStorageFacility, ValFormrow.DrainageSystem, ValFormrow.NoOfLifts, ValFormrow.AreaOfEachLift, ValFormrow.InternalRoad, ValFormrow.ValuatedBefore, ValFormrow.ValuationFormId, curUser, DateTime.Now); // Delete and Insert all the documents that are attached to this ValuationForm IgrssAdapters.AdjudicationDocumentAdapter.DeleteDocumentDetailByValuationFormId(ValuationFormId); foreach (DataRow DocDetail in DocDetails.Rows) { IgrssAdapters.AdjudicationDocumentAdapter.AddAdjudicationDocument(ValuationFormId, (Guid)DocDetail["DocumentTypeId"], Convert.ToBoolean(DocDetail["Submitted"]), Convert.ToString(DocDetail["DocumentNumber"]), Convert.ToString(DocDetail["Remarks"])); } return true; } catch (Exception ex) { throw ex; } }
public bool AddNewRegistration(FormViewParameter Parameter, DataTable PartyDetails, Guid Id, DataTable FeeDetails,DataTable DocDetails,Remarks rem) { IGRSS.DataAccessLayer.Registration.InputSheetRow row = (IGRSS.DataAccessLayer.Registration.InputSheetRow) Parameter.Values; Guid ValuationFormId = Id; string curUser = Thread.CurrentPrincipal.Identity.Name; Guid RegistrationId = FileManager.OpenNewFile(row.OfficeId, "REG"); FileManager.AddRemarkToFile(RegistrationId,rem.Subject,rem.Body); //ViewState["ValuationFormId"] = ValuationFormId; IgrssAdapters.InputSheet.AddNewInputSheet(RegistrationId, row.OfficeId, row.RegistrationTypeId,ValuationFormId, row.FilePrefix, row.FileSlNo, row.FileYear, row.ApplnDate, row.ApplicantName, row.ApplnAddress, row.PropertyValue, row.IsRented, row.LeasePeriodFrom, row.LeasePeriodTo, row.DepositAmount, row.Tax, row.YearlyRent, row.StampDutyUsed, curUser, DateTime.Now); foreach (DataRow PartyDetail in PartyDetails.Rows) { IgrssAdapters.RegistrationPartyDetails.AddNewPartyDetails(Guid.NewGuid(), RegistrationId, (string) PartyDetail["PartyType"], (string) PartyDetail["Name"], (string) PartyDetail["Address"], (decimal) PartyDetail["Age"], (string) PartyDetail["Gender"], (Guid) PartyDetail["Religion"], (string) PartyDetail["Occupation"], (string) PartyDetail["Occupation"], curUser, DateTime.Now); } foreach (DataRow FeeDetail in FeeDetails.Rows) { IgrssAdapters.RegistrationFeeDetails.AddNewRegistrationFee(RegistrationId, (Guid) FeeDetail["FeeId"], Convert.ToDecimal(FeeDetail["Amount"])); } foreach (DataRow DocDetail in DocDetails.Rows) { IgrssAdapters.RegistrationDocumentCheckList.AddNewRegistrationDocuments(RegistrationId, (Guid) DocDetail["DocumentTypeId"], Convert.ToBoolean(DocDetail["Submitted"]), Convert.ToString(DocDetail["DocumentNumber"]), Convert.ToString(DocDetail["Remarks"])); } return true; }
public bool AddNewActMaster(FormViewParameter Parameter) { string curUser = Thread.CurrentPrincipal.Identity.Name; Guid ActId=Guid.NewGuid(); IGRSS.DataAccessLayer.ActMaster.ActMasterRow row = (IGRSS.DataAccessLayer.ActMaster.ActMasterRow) Parameter.Values; IgrssAdapters.ActMasterAdapter.AddNewActMaster(ActId, row.DescriptionOfAct, row.NameOfAct, curUser, DateTime.Now); return true; }
public bool AddNewOffices(FormViewParameter Parameter) { // Guid OfficeId = Guid.NewGuid(); // string curUser = Thread.CurrentPrincipal.Identity.Name; // IGRSS.DataAccessLayer.OfficesMaster.OfficeMasterRow row = (IGRSS.DataAccessLayer.OfficesMaster.OfficeMasterRow) Parameter.Values; // IgrssAdapters.OfficesAdapter.AddNewOffice(OfficeId, row.OfficeName, row.OfficeTypeId, row.Description, curUser, DateTime.Now); return true; }
public bool AddNewOfficeCommunication(FormViewParameter Parameter) { string curUser = Thread.CurrentPrincipal.Identity.Name; IGRSS.DataAccessLayer.OfficesMaster.OfficesCommunication_LKPRow row= (IGRSS.DataAccessLayer.OfficesMaster.OfficesCommunication_LKPRow)Parameter.Values; IgrssAdapters.OfficeCommunication_LKP.AddNewOfficeCommunication(row.OfficeId, row.CommunicationKey, row.CommunicatingOffice, row.Description, row.IsActive, curUser, DateTime.Now); return true; }
public bool AddNewUserInOfficeRoles(FormViewParameter Parameter,string UserName) { IGRSS.DataAccessLayer.WorkflowSupprot.UsersInOfficeRolesRow row = (IGRSS.DataAccessLayer.WorkflowSupprot.UsersInOfficeRolesRow) Parameter.Values; string curUser = Thread.CurrentPrincipal.Identity.Name; IgrssAdapters.UsersInOfficeRole.UpdateUserInOfficeRoles(UserName, row.DesignationID, row.OfficeId, row.Comments, row.IsActive, curUser, DateTime.Now); return true; }
public void AddVendorDetails(FormViewParameter Parameter) { string curUser = Thread.CurrentPrincipal.Identity.Name; try { IGRSS.DataAccessLayer.VendorMaster.VendorMasterRow Row = (IGRSS.DataAccessLayer.VendorMaster.VendorMasterRow) Parameter.Values; VendorAdapter.AddNewVendorDetails(Guid.NewGuid(), Row.VendorType, Row.CompanyName, Row.VendorName, Row.Address, Row.Phone, Row.ContactPerson, curUser, DateTime.Now); } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; } }
public bool AddNewEmployeeMaster(FormViewParameter Parameter, DataTable dtQualification) { IGRSS.DataAccessLayer.Employee.EmployeeMasterRow row = (IGRSS.DataAccessLayer.Employee.EmployeeMasterRow) Parameter.Values; DataTable dt = IgrssAdapters.EmployeeMaster.SelectEmployeeDetailsByEmpNo(row.EmployeeNo); if (dt.Rows.Count==0) { Guid EmployeeId = Guid.NewGuid(); string curUser = Thread.CurrentPrincipal.Identity.Name; try { IgrssAdapters.EmployeeMaster.InsertEmployeeMaster(EmployeeId, row.EmployeeNo, row.FirstName, row.MiddleName, row.PostalAddress, row.PermanentAddress, row.DateOfBirth, row.FatherName, row.Height, row.VisibleMarks, row.OfficeID, row.DepartmentID, row.DesignationID, row.Salary, row.Allowances, row.StartDate, curUser, DateTime.Now); foreach (DataRow drQualifications in dtQualification.Rows) { IgrssAdapters.EmployeeQualifications.InsertEmployeeQualification(Guid.NewGuid(), EmployeeId, (Guid) drQualifications["QualificationID"], (string) drQualifications["Details"], curUser, DateTime.Now); } } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; } return true; } else return false; }
public bool AddLeaveDetails(FormViewParameter Parameter) { string curUser = Thread.CurrentPrincipal.Identity.Name; try { IGRSS.DataAccessLayer.Leave.LeaveRegisterRow Row = (IGRSS.DataAccessLayer.Leave.LeaveRegisterRow) Parameter.Values; IgrssAdapters.LeaveAdapter.AddLeaveDetails(Guid.NewGuid(), Row.EmployeeID, Row.ApplnDate, Row.ApplicableRules, Row.LeaveType, Row.LeaveFrom, Row.LeaveTo, Row.WorkingDays, Row.Reason, Row.ResumedDutyOn, curUser, DateTime.Now); } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; } return true; }
public void AddVendorOffence(FormViewParameter Parameter, Guid LicenseId) { try { IGRSS.DataAccessLayer.VendorOffence.VendorOffenceRow Row = (IGRSS.DataAccessLayer.VendorOffence.VendorOffenceRow)Parameter.Values; FileidId = FileManager.OpenNewFile(Row.OfficeId, "LIC"); IgrssAdapters.VOffenceAdapter.AddNewVendorOffence(FileidId, Row.OfficeId, Row.Name, Row.Summary, Row.Details, Row.OffenceDate, LicenseId); } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; } }
//string ComplaintNo, Guid ComplaintType, Guid AgainstEmpID, Guid ComplainingEmpID, string ComplainantName, string ComplainantAddress, DateTime ComplaintDate, Guid ReceivingOfficeId, string Subject, string Detail) /// <summary> /// This function will add the new Complain. /// </summary> /// <returns>void</returns> public bool AddNewComplain(FormViewParameter Parameter, Remarks rem) { string curUser = Thread.CurrentPrincipal.Identity.Name; int i = 0; ComplainDetailsRow row = (ComplainDetailsRow)Parameter.Values; try { Guid ComplainId = FileManager.OpenNewFile(row.ReceivingOfficeId, "COM"); // Commented By Akhilesh. //if (rem.Subject != "" && rem.Body != "") //{ // FileManager.AddRemarkToFile(ComplainId, rem.Subject, rem.Body); //} int rowsAffected=0; if(row.ComplaintType == new Guid("85aefd8d-6b7e-4ab8-b124-21b52073f7b3")) { i=IgrssAdapters.ComplainAdapter.AddNewComplainDetails(ComplainId, row.ComplaintNo, row.ComplaintType, row.AgainstEmpID, row.ComplainingEmpID, row.ComplainantName, row.ComplainantAddress, row.ComplaintDate, row.ReceivingOfficeId, row.Subject, row.Detail, curUser, DateTime.Now,row.Designation,row.CurrentOffice); } if (row.ComplaintType == new Guid("96369687-0450-42fc-ba41-ad35ade13b53")) { i=IgrssAdapters.ComplainAdapter.AddNewComplainDetails(ComplainId, row.ComplaintNo, row.ComplaintType, row.AgainstEmpID, row.ComplainingEmpID, row.ComplainantName, row.ComplainantAddress, row.ComplaintDate, null, row.Subject, row.Detail, curUser, DateTime.Now, row.Designation, null); } if (i > 0) { Dictionary<string, object> WfParams = new Dictionary<string, object>(); WfParams.Add("ComplainId", ComplainId); WfParams.Add("ComplainOffice", row.ReceivingOfficeId); WorkflowResults WfResult = WorkflowMediator.RunWorkflow(typeof(ComplainProcess), WfParams); return true; } else { return false; } } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; return false; } }
public bool AddAppealAplication(FormViewParameter parameter, DataTable dtAct,Remarks rem) { //Initiate some of the fields required for the process AppealApplicationRow rowApl = (AppealApplicationRow)parameter.Values; Guid AppealId = FileManager.OpenNewFile(rowApl.OfficeId, "APL"); FileManager.AddRemarkToFile(AppealId, rem.Subject, rem.Body); string curUser = Thread.CurrentPrincipal.Identity.Name; int i = 0; try { IGRSS.DataAccessLayer.Appeal.AppealApplicationRow row = (AppealApplicationRow) parameter.Values; i=IgrssAdapters.AppealAdapter.AddAppealApplication(AppealId, row.OfficeId, row.RegistrationNo, row.ApplicantName, row.Address, row.TypeOfAppeal, row.CalculatedAmount, row.DepositAmount, row.FeeReceiptNo, row.Amount, row.InwardDate, row.IsPaidAppealFee, row.AppealInTime, row.PaperFromTo, row.CourtFeeTicket, curUser, DateTime.Now, row.DocumentNo, row.OriginalSRO, row.DocumentDate, row.DaTeOffOrderFromCollector, row.DficitAmount,row.ReceiptNo,row.ReceiptDate); if (i > 0) { foreach (DataRow dr in dtAct.Rows) { IgrssAdapters.AppealActAdapter.AddAppealAct(AppealId, (Guid)dr["ActId"], (bool)dr["Checked"]); } // All database Inserts have been completed sucessfully initiate the Workflow // Create a Dioctionary to store Workflow Paramaters for Appeal Dictionary<string, object> WfParams = new Dictionary<string, object>(); // Add Refund Application Id into the Workflow Parameter WfParams.Add("AppealId", AppealId); // Add Office Id in to Workflow Parameter // (to identify the process flow for the Office) WfParams.Add("InitiatingOffice", row.OfficeId); // Initiate the Refund Workflow by passing the Wf Parameters Dictionary WorkflowResults WfResult = WorkflowMediator.RunWorkflow(typeof(AppealProcess), WfParams); return true; } else { return false; } } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; return false; } }
public void AddLeaveDetailsTest() { IGRSS.BusinessLogicLayer.Leave target = new IGRSS.BusinessLogicLayer.Leave(); FormViewParameter Parameter =new FormViewParameter(); // TODO: Initialize to an appropriate value IGRSS.DataAccessLayer.Leave.LeaveRegisterDataTable Dt = new IGRSS.DataAccessLayer.Leave.LeaveRegisterDataTable(); DataRow dr = Dt.NewRow(); dr["EmployeeID"] = new Guid("fc9b70d5-9344-4059-87f2-a9d082601c76"); dr["LeaveType"] = new Guid("9ec9c473-dd5d-47af-885a-59a65a5bb651"); dr["LeaveFrom"] = DateTime.Now; dr["LeaveTo"] = DateTime.Now; dr["Reason"] ="just not filing well"; dr["ResumedDutyOn"] = DateTime.Now.AddDays(5); Parameter.Values = Dt.Rows[0]; Dt.Rows.Add(dr); bool expected = true; Assert.AreEqual(expected, target.AddLeaveDetails(Parameter), "IGRSS.BusinessLogicLayer.Leave.AddLeaveDetails did not return the expected value." + ""); }
public void AddAppealAplicationTest() { IGRSS.BusinessLogicLayer.AppealApplication target = new IGRSS.BusinessLogicLayer.AppealApplication(); FormViewParameter Parameter = new FormViewParameter(); IGRSS.DataAccessLayer.Appeal.AppealApplicationDataTable dt = new IGRSS.DataAccessLayer.Appeal.AppealApplicationDataTable(); DataRow dr = dt.NewRow(); dr["AppealApplicationId"] = new Guid(); dr["AppealPrefix"] = "YSL"; dr["AppealSlNo"]="22210"; dr["AppealYear"]=2006; dr["OfficeId"]=new Guid("514ba1d5-61fb-4b9d-abfd-0dff857ca05d"); dr["RegistrationNo"]="324444"; dr["ApplicantName"]="BASKAR"; dr["Address"]="Chennai"; dr["TypeOfAppeal"]=2; dr["CalculatedAmount"]=500; dr["DepositAmount"] = 200; dr["FeeReceiptNo"]="467"; dr["Amount"]="500"; dr["InwardDate"]=DateTime.Now; dr["IsPaidAppealFee"]=true; dr["AppealInTime"]=true; dr["PaperFromTo"]="ssss"; dr["CourtFeeTicket"]=true; dr["AppealRemarks"]="short listed"; dr["CreatedBy"] = "sahu"; dr["DocumentNo"]="3333"; dr["OriginalSRO"] = new Guid("916fd082-061a-45fb-91a4-33967243b4cf"); dr["DocumentDate"] = DateTime.Now; dt.Rows.Add(dr); Parameter.Values = dt.Rows[0]; DataTable dtAct = new DataTable(); dtAct.Columns.Add("ActId", typeof(Guid)); dtAct.Columns.Add("Checked", typeof(bool)); DataRow actDR; actDR = dtAct.NewRow(); actDR["ActId"] = new Guid("eee9b625-be85-4715-920b-3ed6ec0f4470"); actDR["Checked"] = true; dtAct.Rows.Add(actDR); target.AddAppealAplication(Parameter, dtAct); bool expected = true; Assert.AreEqual(expected,target.AddAppealAplication(Parameter, dtAct), "IGRSS.BusinessLogicLayer.Leave.AddLeaveDetails did not return the expected value." + ""); }
public bool AddNewvendorInvestigationDetails(FormViewParameter Parameter,Guid OffenceId,string InvestigationType,string Remarks) { try { IGRSS.DataAccessLayer.VendorOffence.VendorInvestigationRow Row = (IGRSS.DataAccessLayer.VendorOffence.VendorInvestigationRow)Parameter.Values; int i=IgrssAdapters.VInspectionAdapter.AddNewvendorInvestigationDetails(OffenceId, Guid.NewGuid(),InvestigationType,Row.Date, Row.Participants, Row.Summary, Row.Details,Row.IsJudgement,Remarks); if (i == 1) return true; else return false; } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; return false; } }
public bool AddServiceDetails(FormViewParameter Parameter) { string curUser = Thread.CurrentPrincipal.Identity.Name; try { IGRSS.DataAccessLayer.Service.ServiceRegisterRow Row = (IGRSS.DataAccessLayer.Service.ServiceRegisterRow) Parameter.Values; int i=IgrssAdapters.ServiceAdapter.AddNewServiceDetails(Guid.NewGuid(), Row.ServiceNo, Row.VendorID, Row.ServiceDate, Row.InChargeEmpID, Row.InstrumentRepaired, Row.Remarks, curUser, DateTime.Now); if (i == 1) return true; else return false; } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; return false; } }
public bool AddTest(FormViewParameter Parameter) { //, Row.DeliveryBranch, Row.DocumentSender, Row.ReceiversName try { IGRSS.DataAccessLayer.TestTable.TestRow Row = (IGRSS.DataAccessLayer.TestTable.TestRow)Parameter.Values; int i = IgrssAdapters.TestTableAdapter.InsertQuery(1,"Urvi" ); if (i == 1) return true; else return false; } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; return false; } }
public bool AddOutWardDetails(FormViewParameter Parameter) { string curUser = Thread.CurrentPrincipal.Identity.Name; try { IGRSS.DataAccessLayer.InwardOutward.Inward_OutwardRegisterRow Row = (IGRSS.DataAccessLayer.InwardOutward.Inward_OutwardRegisterRow)Parameter.Values; //int i = IgrssAdapters.InwardAdapter.AddOutwardDetails(Guid.NewGuid(), "", Row.DocumentNo, Row.InOutDate, Row.DocType, Row.SentOfficeID, Row.ReceivingOfficeID, Row.DocumentSentFrom, Row.DocumentSentTo, Row.Description, Row.StampValueAffixed, Row.DeliveryType, Row.Remarks, curUser, DateTime.Now, Row.DeliveryBranch, Row.DocumentSender, Row.ReceiversName); //if (i == 1) // return true; //else return false; } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; return false; } }
public void AddNewEmployeeMasterTest() { IGRSS.BusinessLogicLayer.Employee target = new IGRSS.BusinessLogicLayer.Employee(); FormViewParameter Parameter = new FormViewParameter(); IGRSS.DataAccessLayer.Employee.EmployeeMasterDataTable dt = new IGRSS.DataAccessLayer.Employee.EmployeeMasterDataTable(); DataRow dr = dt.NewRow(); dr["EmployeeId"] = new Guid(); dr["EmployeeNo"] = "234"; dr["FirstName"] = "PRADEEP"; dr["MiddleName"] ="sahu"; dr["LastName"] = "NITHYANAND"; dr["PostalAddress"] = "SSSSSSSSSSS"; dr["PermanentAddress"] = "FFFFFFFFF"; dr["DateOfBirth"] = DateTime.Now; dr["FatherName"] = "BANGALORE"; dr["Height"] = 12; dr["VisibleMarks"] = 5; dr["OfficeID"] = new Guid("916fd082-061a-45fb-91a4-33967243b4cf"); dr["DepartmentID"] = new Guid("8971ce62-34a8-4175-9e1f-8d4bcc1721a1"); dr["DesignationID"] = new Guid("7c83e591-a861-4b4f-bd1d-12f99cc32123"); dr["Salary"] = 200; dr["Allowances"] = 200; dr["StartDate"] = DateTime.Now; dr["CreatedBy"] = "RAJA"; dt.Rows.Add(dr); Parameter.Values = dt.Rows[0]; DataTable dtQualification = new DataTable(); dtQualification.Columns.Add("QualificationID", typeof(Guid)); dtQualification.Columns.Add("Details", typeof(string)); DataRow drQualification; drQualification = dtQualification.NewRow(); drQualification["QualificationID"] = new Guid("5e48e449-fb3f-4352-9e11-080c91329566"); drQualification["Details"] = "gsgssgsgs"; dtQualification.Rows.Add(drQualification); Assert.AreEqual(true, target.AddNewEmployeeMaster(Parameter, dtQualification), "IGRSS.BusinessLogicLayer.Employee.AddNewEmployeeMaster did not return the expecte" + "d value."); }
public void AddNewComplainTest() { IGRSS.BusinessLogicLayer.Complain target = new IGRSS.BusinessLogicLayer.Complain(); FormViewParameter Parameter = new FormViewParameter(); IGRSS.DataAccessLayer.Complain.ComplainDetailsDataTable dt = new IGRSS.DataAccessLayer.Complain.ComplainDetailsDataTable(); DataRow dr = dt.NewRow(); dr["ComplainId"] = new Guid(); dr["ComplaintNo"] = "YSL456"; dr["ComplaintType"] = new Guid("85aefd8d-6b7e-4ab8-b124-21b52073f7b3"); dr["AgainstEmpID"] = new Guid("3c1820f7-bf70-499d-af99-1eb47a33cd9a"); dr["ComplainingEmpID"] = new Guid("3c1820f7-bf70-499d-af99-1eb47a33cd9a"); dr["ComplainantName"] = "Sandhya"; dr["ComplainantAddress"] = "BASKAR RAO,CHENNAI"; dr["ComplaintDate"] =DateTime.Now; dr["ReceivingOfficeId"] = new Guid("d12d7a4b-bb0b-4af7-badf-03f44efd73e7"); dr["Subject"] ="I AM NOT FILLING WELL SO I COULD'NT COME"; dr["Detail"] = "I AM NOT FILLING WELL SO I COULD'NT COME"; dr["CreatedBy"] = "admin"; dt.Rows.Add(dr); Parameter.Values = dt.Rows[0]; bool expected = true; Assert.AreEqual(expected,target.AddNewComplain(Parameter), "IGRSS.BusinessLogicLayer.Leave.AddLeaveDetails did not return the expected value." + ""); }
public bool UpdateQualificationMaster(FormViewParameter Parameter, Guid QualificationID) { string userName = Thread.CurrentPrincipal.Identity.Name; IGRSS.DataAccessLayer.Employee.QualificationMasterRow row = (IGRSS.DataAccessLayer.Employee.QualificationMasterRow) Parameter.Values; try { int i=IgrssAdapters.QualificationMaster.UpdateQualificationMaster(QualificationID, row.Name, row.Description, userName, DateTime.Now); if (i == 1) return true; else return false; } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; return false; } }
public bool UpdateEmployeeMaster(Guid EmployeeID, FormViewParameter Parameters, DataTable QualificationDetails) { string curUser = Thread.CurrentPrincipal.Identity.Name; try { IGRSS.DataAccessLayer.Employee.EmployeeMasterRow row = (IGRSS.DataAccessLayer.Employee.EmployeeMasterRow) Parameters.Values; IgrssAdapters.EmployeeMaster.UpdateEmployeeMaster(EmployeeID, row.EmployeeNo, row.FirstName, row.MiddleName, row.PostalAddress, row.PermanentAddress, row.DateOfBirth, row.FatherName, row.Height, row.VisibleMarks, row.OfficeID, row.DepartmentID, row.DesignationID, row.Salary, row.Allowances, row.StartDate, row.EndDate, curUser, DateTime.Now); IgrssAdapters.EmployeeQualifications.DeleteEmployeeQualification(EmployeeID); foreach (DataRow drQualifications in QualificationDetails.Rows) { IgrssAdapters.EmployeeQualifications.InsertEmployeeQualification((Guid) drQualifications["EmployeeQualiID"], EmployeeID, (Guid) drQualifications["QualificationID"], "", curUser, DateTime.Now); } } catch (Exception ex) { if (ExceptionPolicy.HandleException(ex, "DAL")) throw; } return true; }
public bool UpdateYearlyInspection(FormViewParameter Parameter, DataTable ScheduleDetails, DataTable SelectedOffices,Guid ScheduleId) { IGRSS.DataAccessLayer.Inspection.InspectionYearlySheduleRow row = (IGRSS.DataAccessLayer.Inspection.InspectionYearlySheduleRow) Parameter.Values; string curUser = Thread.CurrentPrincipal.Identity.Name; IgrssAdapters.InspYearlyScheduleDetail.DeleteYearlyInspectionDetailsById(ScheduleId); IgrssAdapters.InspYearlyShedule.UpdateYearlyInspectionSchedules(ScheduleId, row.OfficerId, Guid.Empty, row.Year, row.Remarks, curUser, DateTime.Now); foreach (DataRow ScheduleDetail in ScheduleDetails.Rows) { IgrssAdapters.InspYearlyScheduleDetail.AddYearlyInspectionScheduleDetails((Guid)ScheduleDetail["DetailScheduleId"], ScheduleId, (decimal)ScheduleDetail["Month"], (string)ScheduleDetail["Remarks"], curUser, DateTime.Now); } foreach (DataRow SelectedOffice in SelectedOffices.Rows) { IgrssAdapters.InspYearlyScheduleMonthwise.AddYearlyScheduleMonthwise((Guid)SelectedOffice["MonthlyScheduleId"], (Guid)SelectedOffice["DetailScheduleId"], (Guid)SelectedOffice["InspectingOfficeId"]); } return true; }
public bool UpdateInspectionTypeMaster(FormViewParameter Parameter, Guid InspectionTypeId) { IGRSS.DataAccessLayer.InspectionDetails.InspectionTypeMasterRow row = (IGRSS.DataAccessLayer.InspectionDetails.InspectionTypeMasterRow)Parameter.Values; string curUser = Thread.CurrentPrincipal.Identity.Name; IgrssAdapters.InspTypeMaster.UpdateInspectionTypeMaster(InspectionTypeId, row.Name, row.Description, curUser, DateTime.Now); return true; }
public bool UpdateInspectionItenary(FormViewParameter Parameter,Guid ItenaryId, Guid ScheduleId) { IGRSS.DataAccessLayer.Inspection.InspectionItenaryRow row = (IGRSS.DataAccessLayer.Inspection.InspectionItenaryRow) Parameter.Values; string curUser = Thread.CurrentPrincipal.Identity.Name; IgrssAdapters.InspItenary.RemoveItenary(ItenaryId); IgrssAdapters.InspItenary.AddInspectionItenary(ItenaryId, ScheduleId, row.Month, row.InspectingDate, row.InspectingOfficeId, row.EndDate, row.ItenaryDetails, curUser, DateTime.Now); return true; }