Exemple #1
0
        public GJournalsCreditDetails Details(long GJournalCreditID)
        {
            try
            {
                string SQL = "SELECT " +
                             "GJournalCreditID, " +
                             "GJournalID, " +
                             "a.ChartOfAccountID, " +
                             "ChartOfAccountCode, " +
                             "ChartOfAccountName, " +
                             "Amount " +
                             "FROM tblGJournalCredit a INNER JOIN tblChartOfAccount b " +
                             "ON a.ChartOfAccountID = b.ChartOfAccountID " +
                             "WHERE GJournalCreditID = @GJournalCreditID;";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmGJournalCreditID = new MySqlParameter("@GJournalCreditID", MySqlDbType.Int64);
                prmGJournalCreditID.Value = GJournalCreditID;
                cmd.Parameters.Add(prmGJournalCreditID);

                MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);

                GJournalsCreditDetails Details = new GJournalsCreditDetails();

                while (myReader.Read())
                {
                    Details.GJournalCreditID = GJournalCreditID;
                    Details.GJournalID       = myReader.GetInt64("GJournalID");
                    Details.ChartOfAccountID = myReader.GetInt32("ChartOfAccountID");
                    Details.Amount           = myReader.GetDecimal("Amount");
                }

                myReader.Close();

                return(Details);
            }

            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
Exemple #2
0
        public void Update(GJournalsCreditDetails Details)
        {
            try
            {
                string SQL = "UPDATE tblGJournalCredit SET " +
                             "GJournalID			=	@GJournalID, "+
                             "ChartOfAccountID	=	@ChartOfAccountID, "+
                             "Amount				=	@Amount "+
                             "WHERE GJournalCreditID	=	@GJournalCreditID;";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64);
                prmGJournalID.Value = Details.GJournalID;
                cmd.Parameters.Add(prmGJournalID);

                MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID", MySqlDbType.Int64);
                prmChartOfAccountID.Value = Details.ChartOfAccountID;
                cmd.Parameters.Add(prmChartOfAccountID);

                MySqlParameter prmAmount = new MySqlParameter("@Amount", MySqlDbType.Decimal);
                prmAmount.Value = Details.Amount;
                cmd.Parameters.Add(prmAmount);

                MySqlParameter prmGJournalCreditID = new MySqlParameter("@GJournalCreditID", MySqlDbType.Int64);
                prmGJournalCreditID.Value = Details.GJournalCreditID;
                cmd.Parameters.Add(prmGJournalCreditID);

                base.ExecuteNonQuery(cmd);
            }

            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
Exemple #3
0
        public long Insert(GJournalsCreditDetails Details)
        {
            try
            {
                string SQL = "INSERT INTO tblGJournalCredit (" +
                             "GJournalID, " +
                             "ChartOfAccountID, " +
                             "Amount" +
                             ") VALUES (" +
                             "@GJournalID, " +
                             "@ChartOfAccountID, " +
                             "@Amount" +
                             ");";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID", MySqlDbType.Int64);
                prmGJournalID.Value = Details.GJournalID;
                cmd.Parameters.Add(prmGJournalID);

                MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID", MySqlDbType.Int64);
                prmChartOfAccountID.Value = Details.ChartOfAccountID;
                cmd.Parameters.Add(prmChartOfAccountID);

                MySqlParameter prmAmount = new MySqlParameter("@Amount", MySqlDbType.Decimal);
                prmAmount.Value = Details.Amount;
                cmd.Parameters.Add(prmAmount);

                base.ExecuteNonQuery(cmd);

                SQL = "SELECT LAST_INSERT_ID();";

                cmd.Parameters.Clear();
                cmd.CommandText = SQL;

                string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
                base.MySqlDataAdapterFill(cmd, dt);

                Int64 iID = 0;

                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    iID = Int64.Parse(dr[0].ToString());
                }

                return(iID);
            }

            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
		public long Insert(GJournalsCreditDetails Details)
		{
			try 
			{
				string SQL = "INSERT INTO tblGJournalCredit (" +
								"GJournalID, " +
								"ChartOfAccountID, " +
								"Amount" +
							") VALUES (" +
								"@GJournalID, " +
								"@ChartOfAccountID, " +
								"@Amount" +
							");";
				  
				
	 			
				MySqlCommand cmd = new MySqlCommand();
				
				
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID",MySqlDbType.Int64);			
				prmGJournalID.Value = Details.GJournalID;
				cmd.Parameters.Add(prmGJournalID);

				MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID",MySqlDbType.Int64);			
				prmChartOfAccountID.Value = Details.ChartOfAccountID;
				cmd.Parameters.Add(prmChartOfAccountID);

				MySqlParameter prmAmount = new MySqlParameter("@Amount",MySqlDbType.Decimal);			
				prmAmount.Value = Details.Amount;
				cmd.Parameters.Add(prmAmount);
     
				base.ExecuteNonQuery(cmd);

                SQL = "SELECT LAST_INSERT_ID();";

                cmd.Parameters.Clear();
                cmd.CommandText = SQL;

                string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
                base.MySqlDataAdapterFill(cmd, dt);

                Int64 iID = 0;

                foreach (System.Data.DataRow dr in dt.Rows)
                {
                    iID = Int64.Parse(dr[0].ToString());
                }

				return iID;
			}

			catch (Exception ex)
			{
				
				
				{
					
					 
					
					
				}

				throw base.ThrowException(ex);
			}	
		}
		public GJournalsCreditDetails Details(long GJournalCreditID)
		{
			try
			{
				string SQL =	"SELECT " +
									"GJournalCreditID, " +
									"GJournalID, " +
									"a.ChartOfAccountID, " +
									"ChartOfAccountCode, " +
									"ChartOfAccountName, " +
									"Amount " +
								"FROM tblGJournalCredit a INNER JOIN tblChartOfAccount b " +
									"ON a.ChartOfAccountID = b.ChartOfAccountID " +
								"WHERE GJournalCreditID = @GJournalCreditID;";
				  
				
	 			
				MySqlCommand cmd = new MySqlCommand();
				
				
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				MySqlParameter prmGJournalCreditID = new MySqlParameter("@GJournalCreditID",MySqlDbType.Int64);			
				prmGJournalCreditID.Value = GJournalCreditID;
				cmd.Parameters.Add(prmGJournalCreditID);

				MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
				
				GJournalsCreditDetails Details = new GJournalsCreditDetails();

				while (myReader.Read()) 
				{
					Details.GJournalCreditID = GJournalCreditID;
					Details.GJournalID = myReader.GetInt64("GJournalID");
					Details.ChartOfAccountID = myReader.GetInt32("ChartOfAccountID");
					Details.Amount = myReader.GetDecimal("Amount");
				}

				myReader.Close();

				return Details;
			}

			catch (Exception ex)
			{
				
				
				{
					
					 
					
					
				}

				throw base.ThrowException(ex);
			}	
		}
		public void Update(GJournalsCreditDetails Details)
		{
			try 
			{
				string SQL = "UPDATE tblGJournalCredit SET " + 
								"GJournalID			=	@GJournalID, " +
								"ChartOfAccountID	=	@ChartOfAccountID, " +
								"Amount				=	@Amount " +
							"WHERE GJournalCreditID	=	@GJournalCreditID;";
				  
				
	 			
				MySqlCommand cmd = new MySqlCommand();
				
				
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				MySqlParameter prmGJournalID = new MySqlParameter("@GJournalID",MySqlDbType.Int64);			
				prmGJournalID.Value = Details.GJournalID;
				cmd.Parameters.Add(prmGJournalID);

				MySqlParameter prmChartOfAccountID = new MySqlParameter("@ChartOfAccountID",MySqlDbType.Int64);			
				prmChartOfAccountID.Value = Details.ChartOfAccountID;
				cmd.Parameters.Add(prmChartOfAccountID);

				MySqlParameter prmAmount = new MySqlParameter("@Amount",MySqlDbType.Decimal);			
				prmAmount.Value = Details.Amount;
				cmd.Parameters.Add(prmAmount);

				MySqlParameter prmGJournalCreditID = new MySqlParameter("@GJournalCreditID",MySqlDbType.Int64);				
				prmGJournalCreditID.Value = Details.GJournalCreditID;
				cmd.Parameters.Add(prmGJournalCreditID);

				base.ExecuteNonQuery(cmd);
			}

			catch (Exception ex)
			{
				
				
				{
					
					 
					
					
				}

				throw base.ThrowException(ex);
			}	
		}
Exemple #7
0
		private void SaveCredit()
		{
			GJournalsCreditDetails clsDetails = new GJournalsCreditDetails();
			
			clsDetails.GJournalID = Convert.ToInt64(lblGJournalID.Text);
			clsDetails.ChartOfAccountID = Convert.ToInt32(cboAccount.SelectedItem.Value);
			clsDetails.Amount = Convert.ToDecimal(txtAmount.Text);

			GJournalsCredit clsGJournalsCredit = new GJournalsCredit();
			clsGJournalsCredit.Insert(clsDetails);
			clsGJournalsCredit.CommitAndDispose();
		}