private void tsmModeOfPayment_Click(object sender, EventArgs e) { try { foreach (TabPage _tab in this.tbcNSites_V.TabPages) { if (_tab.Text == "ModeOfPayment List") { tbcNSites_V.SelectedTab = _tab; return; } } ModeOfPayment _ModeOfPayment = new ModeOfPayment(); Type _Type = typeof(ModeOfPayment); ListFormPOSUI _ListForm = new ListFormPOSUI((object)_ModeOfPayment, _Type); TabPage _ListFormTab = new TabPage(); _ListFormTab.ImageIndex = 16; _ListForm.ParentList = this; displayControlOnTab(_ListForm, _ListFormTab); } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "tsmModeOfPayment_Click"); em.ShowDialog(); return; } }
public ModeOfPaymentDetailUI() { InitializeComponent(); lId = ""; lOperation = GlobalVariables.Operation.Add; loModeOfPayment = new ModeOfPayment(); }
public async Task Test_ModeOfPayment_CRUD() { #region Arrange var tmpAccount = await FortnoxClient.AccountConnector.CreateAsync(new Account() { Description = "TestAccount", Number = TestUtils.GetUnusedAccountNumber() }); #endregion Arrange var connector = FortnoxClient.ModeOfPaymentConnector; #region CREATE var newModeOfPayment = new ModeOfPayment() { Description = "TestMode", AccountNumber = tmpAccount.Number, Code = "TEST_MODE", }; var createdModeOfPayment = await connector.CreateAsync(newModeOfPayment); Assert.AreEqual("TestMode", createdModeOfPayment.Description); #endregion CREATE #region UPDATE createdModeOfPayment.Description = "UpdatedMode"; var updatedModeOfPayment = await connector.UpdateAsync(createdModeOfPayment); Assert.AreEqual("UpdatedMode", updatedModeOfPayment.Description); #endregion UPDATE #region READ / GET var retrievedModeOfPayment = await connector.GetAsync(createdModeOfPayment.Code); Assert.AreEqual("UpdatedMode", retrievedModeOfPayment.Description); #endregion READ / GET #region DELETE await connector.DeleteAsync(createdModeOfPayment.Code); await Assert.ThrowsExceptionAsync <FortnoxApiException>( async() => await connector.GetAsync(createdModeOfPayment.Code), "Entity still exists after Delete!"); #endregion DELETE #region Delete arranged resources await FortnoxClient.AccountConnector.DeleteAsync(tmpAccount.Number); #endregion Delete arranged resources }
public ModeOfPaymentDetailUI(string[] pRecords) { InitializeComponent(); lId = ""; lOperation = GlobalVariables.Operation.Edit; loModeOfPayment = new ModeOfPayment(); lRecords = pRecords; }
public void Test_ModeOfPayment_CRUD() { #region Arrange var tmpAccount = new AccountConnector().Get(0123) ?? new AccountConnector().Create(new Account() { Description = "TestAccount", Number = 0123 }); #endregion Arrange IModeOfPaymentConnector connector = new ModeOfPaymentConnector(); #region CREATE var newModeOfPayment = new ModeOfPayment() { Description = "TestMode", AccountNumber = tmpAccount.Number, Code = "TEST_MODE", }; var createdModeOfPayment = connector.Create(newModeOfPayment); MyAssert.HasNoError(connector); Assert.AreEqual("TestMode", createdModeOfPayment.Description); #endregion CREATE #region UPDATE createdModeOfPayment.Description = "UpdatedMode"; var updatedModeOfPayment = connector.Update(createdModeOfPayment); MyAssert.HasNoError(connector); Assert.AreEqual("UpdatedMode", updatedModeOfPayment.Description); #endregion UPDATE #region READ / GET var retrievedModeOfPayment = connector.Get(createdModeOfPayment.Code); MyAssert.HasNoError(connector); Assert.AreEqual("UpdatedMode", retrievedModeOfPayment.Description); #endregion READ / GET #region DELETE connector.Delete(createdModeOfPayment.Code); MyAssert.HasNoError(connector); retrievedModeOfPayment = connector.Get(createdModeOfPayment.Code); Assert.AreEqual(null, retrievedModeOfPayment, "Entity still exists after Delete!"); #endregion DELETE #region Delete arranged resources new AccountConnector().Delete(0123); #endregion Delete arranged resources }
public FindModeOfPaymentUI() { InitializeComponent(); loModeOfPayment = new ModeOfPayment(); lId = ""; lDescription = ""; lDetails = ""; lFromOK = false; }
public void Test_ModeOfPayment_CRUD() { #region Arrange var tmpAccount = new AccountConnector().Create(new Account() { Description = "TestAccount", Number = TestUtils.GetUnusedAccountNumber() }); #endregion Arrange IModeOfPaymentConnector connector = new ModeOfPaymentConnector(); #region CREATE var newModeOfPayment = new ModeOfPayment() { Description = "TestMode", AccountNumber = tmpAccount.Number, Code = "TEST_MODE", }; var createdModeOfPayment = connector.Create(newModeOfPayment); Assert.AreEqual("TestMode", createdModeOfPayment.Description); #endregion CREATE #region UPDATE createdModeOfPayment.Description = "UpdatedMode"; var updatedModeOfPayment = connector.Update(createdModeOfPayment); Assert.AreEqual("UpdatedMode", updatedModeOfPayment.Description); #endregion UPDATE #region READ / GET var retrievedModeOfPayment = connector.Get(createdModeOfPayment.Code); Assert.AreEqual("UpdatedMode", retrievedModeOfPayment.Description); #endregion READ / GET #region DELETE connector.Delete(createdModeOfPayment.Code); Assert.ThrowsException <FortnoxApiException>( () => connector.Get(createdModeOfPayment.Code), "Entity still exists after Delete!"); #endregion DELETE #region Delete arranged resources new AccountConnector().Delete(tmpAccount.Number); #endregion Delete arranged resources }
private void btnSave_Click(object sender, EventArgs e) { try { if (ScholarshipID.Text == "") { MessageBox.Show("Please select Scholarship ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ScholarshipID.Focus(); return; } if (ScholarNo.Text == "") { MessageBox.Show("Please select Scholar No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ScholarNo.Focus(); return; } if (ModeOfPayment.Text == "") { MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ModeOfPayment.Focus(); return; } if (TotalPaid.Text == "") { MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); TotalPaid.Focus(); return; } if (int.Parse(TotalPaid.Text) > int.Parse(Amount.Text)) { MessageBox.Show("total paid can not be more than scholarship amount", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); TotalPaid.Text = ""; TotalPaid.Focus(); return; } auto(); con = new SqlConnection(cs); con.Open(); string ct = "select ScholarshipPaymentID from ScholarshipPayment where ScholarshipPaymentID=@find"; cmd = new SqlCommand(ct); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "ScholarshipPaymentID")); cmd.Parameters["@find"].Value = ScholarshipPaymentID.Text; rdr = cmd.ExecuteReader(); if (rdr.Read()) { MessageBox.Show("Scholarship Payment ID Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ScholarshipPaymentID.Text = ""; if ((rdr != null)) { rdr.Close(); } return; } con = new SqlConnection(cs); con.Open(); string cb = "insert into ScholarshipPayment(ScholarshipPaymentID,Scholarshipid,Scholarshipname,amount,ScholarNo,StudentName,Course,Branch,PaymentDate,PaymentMode,PaymentModeDetails,TotalPaid,DuePayment) VALUES (@d1,@d2,@d3,@d5,@d6,@d7,@d8,@d9,@d10,@d11,@d12,@d13,@d14)"; cmd = new SqlCommand(cb); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "ScholarshipPaymentID")); cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 20, "ScholarshipID")); cmd.Parameters.Add(new SqlParameter("@d3", System.Data.SqlDbType.NChar, 30, "Scholarshipname")); cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.NChar, 10, "Amount")); cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 15, "ScholarNo")); cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.NChar, 30, "StudentName")); cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.NChar, 20, "Course")); cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.NChar, 30, "Branch")); cmd.Parameters.Add(new SqlParameter("@d10", System.Data.SqlDbType.NChar, 30, "PaymentDate")); cmd.Parameters.Add(new SqlParameter("@d11", System.Data.SqlDbType.NChar, 20, "PaymentMode")); cmd.Parameters.Add(new SqlParameter("@d12", System.Data.SqlDbType.VarChar, 200, "PaymentModeDetails")); cmd.Parameters.Add(new SqlParameter("@d13", System.Data.SqlDbType.NChar, 10, "TotalPaid")); cmd.Parameters.Add(new SqlParameter("@d14", System.Data.SqlDbType.NChar, 10, "DueFees")); cmd.Parameters["@d1"].Value = ScholarshipPaymentID.Text.Trim(); cmd.Parameters["@d2"].Value = ScholarshipID.Text.Trim(); cmd.Parameters["@d3"].Value = ScholarshipName.Text.Trim(); cmd.Parameters["@d5"].Value = Amount.Text.Trim(); cmd.Parameters["@d6"].Value = ScholarNo.Text.Trim(); cmd.Parameters["@d7"].Value = StudentName.Text.Trim(); cmd.Parameters["@d8"].Value = Course.Text.Trim(); cmd.Parameters["@d9"].Value = Branch.Text.Trim(); cmd.Parameters["@d10"].Value = (PaymentDate.Text); cmd.Parameters["@d11"].Value = (ModeOfPayment.Text); cmd.Parameters["@d12"].Value = (PaymentModeDetails.Text); cmd.Parameters["@d13"].Value = (TotalPaid.Text); cmd.Parameters["@d14"].Value = (DuePayment.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); btnSave.Enabled = false; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (ScholarNo.Text == "") { MessageBox.Show("Please select Scholar No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ScholarNo.Focus(); return; } if (FeeID.Text == "") { MessageBox.Show("Please select Fee ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); FeeID.Focus(); return; } if (ModeOfPayment.Text == "") { MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ModeOfPayment.Focus(); return; } if (TotalPaid.Text == "") { MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); TotalPaid.Focus(); return; } con = new SqlConnection(cs.DBConn); con.Open(); string ct = "select FeeID,ScholarNo from FeePayment where FeeID= '" + FeeID.Text + "' and ScholarNo= '" + ScholarNo.Text + "'"; cmd = new SqlCommand(ct); cmd.Connection = con; rdr = cmd.ExecuteReader(); if (rdr.Read()) { MessageBox.Show("Student already paid fees for this semester", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Reset(); if ((rdr != null)) { rdr.Close(); } return; } auto(); con = new SqlConnection(cs.DBConn); con.Open(); string cb = "insert into feepayment(FeePaymentID,ScholarNo,FeeID,FDCourse,FDBranch,Semester,TutionFees,LibraryFees,UniversityDevelopmentFees,UniversityStudentWelfareFees,CautionMoney,OtherFees,TotalFees,DateOfPayment,ModeOfPayment,PaymentModeDetails,TotalPaid,Fine,DueFees) VALUES (@d1,@d2,@d6,@d7,@d8,@d9,@d10,@d11,@d12,@d13,@d14,@d15,@d16,@d17,@d18,@d19,@d20,@d21,@d22)"; cmd = new SqlCommand(cb); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "FeePaymentID")); cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 15, "ScholarNo")); cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 20, "FeeId")); cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.NChar, 20, "FDCourse")); cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.NChar, 30, "FDBranch")); cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.NChar, 10, "Semester")); cmd.Parameters.Add(new SqlParameter("@d10", System.Data.SqlDbType.Int, 10, "TutionFees")); cmd.Parameters.Add(new SqlParameter("@d11", System.Data.SqlDbType.Int, 10, "LibraryFees")); cmd.Parameters.Add(new SqlParameter("@d12", System.Data.SqlDbType.Int, 10, "UniversityDevelopmentFees")); cmd.Parameters.Add(new SqlParameter("@d13", System.Data.SqlDbType.Int, 15, "UniversityStudentWelfareFees")); cmd.Parameters.Add(new SqlParameter("@d14", System.Data.SqlDbType.Int, 10, "CautionMoney")); cmd.Parameters.Add(new SqlParameter("@d15", System.Data.SqlDbType.Int, 10, "OtherFees")); cmd.Parameters.Add(new SqlParameter("@d16", System.Data.SqlDbType.Int, 10, "TotalFees")); cmd.Parameters.Add(new SqlParameter("@d17", System.Data.SqlDbType.NChar, 30, "DateOfPayment")); cmd.Parameters.Add(new SqlParameter("@d18", System.Data.SqlDbType.NChar, 20, "ModeOfPayment")); cmd.Parameters.Add(new SqlParameter("@d19", System.Data.SqlDbType.VarChar, 200, "PaymentModeDetails")); cmd.Parameters.Add(new SqlParameter("@d20", System.Data.SqlDbType.Int, 10, "TotalPaid")); cmd.Parameters.Add(new SqlParameter("@d21", System.Data.SqlDbType.Int, 10, "Fine")); cmd.Parameters.Add(new SqlParameter("@d22", System.Data.SqlDbType.Int, 10, "DueFees")); cmd.Parameters["@d1"].Value = FeePaymentID.Text.Trim(); cmd.Parameters["@d2"].Value = ScholarNo.Text.Trim(); cmd.Parameters["@d6"].Value = FeeID.Text.Trim(); cmd.Parameters["@d7"].Value = FDCourse.Text.Trim(); cmd.Parameters["@d8"].Value = FDBranch.Text.Trim(); cmd.Parameters["@d9"].Value = Semester.Text.Trim(); cmd.Parameters["@d10"].Value = Convert.ToInt32(TutionFees.Text); cmd.Parameters["@d11"].Value = Convert.ToInt32(LibraryFees.Text); cmd.Parameters["@d12"].Value = Convert.ToInt32(UDFees.Text); cmd.Parameters["@d13"].Value = Convert.ToInt32(USFees.Text); if (Semester.Text == "1st") { cmd.Parameters["@d14"].Value = Convert.ToInt32(CautionMoney.Text); } else { cmd.Parameters["@d14"].Value = 0; } cmd.Parameters["@d15"].Value = Convert.ToInt32(OtherFees.Text); cmd.Parameters["@d16"].Value = Convert.ToInt32(TotalFees.Text); cmd.Parameters["@d17"].Value = (PaymentDate.Text); cmd.Parameters["@d18"].Value = (ModeOfPayment.Text); cmd.Parameters["@d19"].Value = (PaymentModeDetails.Text); cmd.Parameters["@d20"].Value = Convert.ToInt32(TotalPaid.Text); if (Fine.Text == "") { cmd.Parameters["@d21"].Value = 0; } else { cmd.Parameters["@d21"].Value = Convert.ToInt32(Fine.Text); } cmd.Parameters["@d22"].Value = Convert.ToInt32(DueFees.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Successfully saved", "Fees Payment Record", MessageBoxButtons.OK, MessageBoxIcon.Information); btnSave.Enabled = false; Print.Enabled = true; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (ScholarNo.Text == "") { MessageBox.Show("Please select Scholar No.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ScholarNo.Focus(); return; } if (ModeOfPayment.Text == "") { MessageBox.Show("Please select mode of payment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ModeOfPayment.Focus(); return; } if (TotalPaid.Text == "") { MessageBox.Show("Please enter total paid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); TotalPaid.Focus(); return; } auto(); con = new SqlConnection(cs.DBConn); con.Open(); string cb = "insert into BusFeePayment(FeePaymentID,ScholarNo,BusCharges,DateOfPayment,ModeOfPayment,PaymentModeDetails,TotalPaid,Fine,DueFees) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9)"; cmd = new SqlCommand(cb); cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@d1", System.Data.SqlDbType.NChar, 20, "FeePaymentID")); cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 15, "ScholarNo")); cmd.Parameters.Add(new SqlParameter("@d3", System.Data.SqlDbType.Int, 10, "BusCharges")); cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 30, "DateOfPayment")); cmd.Parameters.Add(new SqlParameter("@d5", System.Data.SqlDbType.NChar, 20, "ModeOfPayment")); cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.VarChar, 200, "PaymentModeDetails")); cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.Int, 10, "TotalPaid")); cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.Int, 10, "Fine")); cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.Int, 10, "DueFees")); cmd.Parameters["@d1"].Value = FeePaymentID.Text.Trim(); cmd.Parameters["@d2"].Value = ScholarNo.Text.Trim(); cmd.Parameters["@d3"].Value = Convert.ToInt32(txtBusCharges.Text); cmd.Parameters["@d4"].Value = (PaymentDate.Text); cmd.Parameters["@d5"].Value = (ModeOfPayment.Text); cmd.Parameters["@d6"].Value = (PaymentModeDetails.Text); cmd.Parameters["@d7"].Value = Convert.ToInt32(TotalPaid.Text); if (Fine.Text == "") { cmd.Parameters["@d8"].Value = 0; } else { cmd.Parameters["@d8"].Value = Convert.ToInt32(Fine.Text); } cmd.Parameters["@d9"].Value = Convert.ToInt32(DueFees.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); btnSave.Enabled = false; Print.Enabled = true; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Create a new Mode of payment /// </summary> /// <param name="modeOfPayment">The mode of payment to create</param> /// <returns>The created mode of payment</returns> public ModeOfPayment Create(ModeOfPayment modeOfPayment) { return(BaseCreate(modeOfPayment)); }
/// <summary> /// Updates a mode of payment /// </summary> /// <param name="modeofpayment">The mode of payment to update</param> /// <returns>The updated mode of payment</returns> public ModeOfPayment Update(ModeOfPayment modeofpayment) { return(BaseUpdate(modeofpayment, modeofpayment.Code)); }
public string updateModeOfPayment([FromBody] ModeOfPayment pModeOfPayment) { return(loModeOfPayment.updateModeOfPayment(pModeOfPayment)); }
public string insertModeOfPayment([FromBody] ModeOfPayment pModeOfPayment) { return(loModeOfPayment.insertModeOfPayment(pModeOfPayment)); }