public AccountTranaction(bool IsLocal)
 {
     Mycommon = new DataService(IsLocal);
     MyGeneral = new CommonOperations(IsLocal);
     IsLocalLoging = IsLocal;
   
 }
 public BALAcknowledgement(bool IsLocal)
 {
     Mycommon = new DataService(IsLocal);
 }
Exemple #3
0
 public Journal(bool IsLocal)
     {
         Mycommon = new DataService(IsLocal);
     }
        public Boolean DBConnectionIsOk(bool Islocal)
        {
            try
            {
                DataService Myds = new DataService(Islocal);
                return true;
            }
            catch (Exception ex)
            {

                return false;
            }
        }
Exemple #5
0
 public Billing(bool IsLocal)
 {
 Mycommon = new DataService(IsLocal);
 MyGeneral = new CommonOperations(IsLocal);
  }
 public AccountCreation(bool IsLocal)
 {
     Mycommon = new DataService(IsLocal);
     MyGeneral = new CommonOperations(IsLocal);
 }
Exemple #7
0
 public string  GetSupplier(int Sysid, out DataType.SupplierDataType _ExistData,bool IsLocal)
 {
     DataService Mycommon = new DataService(IsLocal);
     _ExistData = new DataType.SupplierDataType();
     MySqlCommand oSqlCommand = new MySqlCommand();
     string sqlQuery = "Select "
   + "Sysid,"
   + "Customer,"
   + "Address1,"
   + "Address2,"
   + "Address3,"
   + "TPN,"
   + "Mobile,"
   + "Fax,"
   + "Email,"
   + "CreditLimit,"
   + "CurrentCredit,"
   + "VatRegNumber,"
   + "Status,"
   + "LastAccUser,"
   + "LastAccDate,"
   + "ContactPerson,"
   + "ContactTPnumber,"
   + "PaymentTerms,"
   + "CreditPeriod,"
   + "DeleveryMethod,"
   + "Shippingadd1,"
   + "ShippingAdd2,"
   + "ShippingAdd3,"
   + "Country,"
   + "CusID,"
   + "FFName,"
   + "FFAccountNo,"
   + "UnderG4,"
   + "Email_OrderAcn,"
   + "Email_Invoice,"
   + "Email_Complain,"
   + "NeedCustomerLogo,"
   + "CurrenyCode"
   + " from tblsupplier"
   + " Where 1=1 "
         + " and Sysid=@Sysid";
     oSqlCommand.Parameters.AddWithValue("@Sysid", Sysid);
     DataRow r = Mycommon.GetDataRow(sqlQuery, oSqlCommand, null, "Get Exist data Supplier");
     if (r != null)
     {
         try
         {
             bool resp = false;
             int inSysid = 0;
             resp = int.TryParse(r["Sysid"].ToString(), out inSysid);
             _ExistData.Sysid = inSysid;
             _ExistData.Customer = r["Customer"].ToString();
             _ExistData.Address1 = r["Address1"].ToString();
             _ExistData.Address2 = r["Address2"].ToString();
             _ExistData.Address3 = r["Address3"].ToString();
             _ExistData.TPN = r["TPN"].ToString();
             _ExistData.Mobile = r["Mobile"].ToString();
             _ExistData.Fax = r["Fax"].ToString();
             _ExistData.Email = r["Email"].ToString();
             decimal deCreditLimit = 0;
             resp = decimal.TryParse(r["CreditLimit"].ToString(), out deCreditLimit);
             _ExistData.CreditLimit = deCreditLimit;
             decimal deCurrentCredit = 0;
             resp = decimal.TryParse(r["CurrentCredit"].ToString(), out deCurrentCredit);
             _ExistData.CurrentCredit = deCurrentCredit;
             _ExistData.VatRegNumber = r["VatRegNumber"].ToString();
             int inStatus = 0;
             resp = int.TryParse(r["Status"].ToString(), out inStatus);
             _ExistData.Status = inStatus;
             _ExistData.LastAccUser = r["LastAccUser"].ToString();
             DateTime dtLastAccDate = new DateTime(1900, 1, 1);
             resp = DateTime.TryParse(r["LastAccDate"].ToString(), out dtLastAccDate);
             if (resp)
                 _ExistData.LastAccDate = dtLastAccDate;
             else
                 _ExistData.LastAccDate = new DateTime(1900, 1, 1);
             _ExistData.ContactPerson = r["ContactPerson"].ToString();
             _ExistData.ContactTPnumber = r["ContactTPnumber"].ToString();
             _ExistData.PaymentTerms = r["PaymentTerms"].ToString();
             int inCreditPeriod = 0;
             resp = int.TryParse(r["CreditPeriod"].ToString(), out inCreditPeriod);
             _ExistData.CreditPeriod = inCreditPeriod;
             _ExistData.DeleveryMethod = r["DeleveryMethod"].ToString();
             _ExistData.Shippingadd1 = r["Shippingadd1"].ToString();
             _ExistData.ShippingAdd2 = r["ShippingAdd2"].ToString();
             _ExistData.ShippingAdd3 = r["ShippingAdd3"].ToString();
             _ExistData.Country = r["Country"].ToString();
             _ExistData.CusID = r["CusID"].ToString();
             _ExistData.FFName = r["FFName"].ToString();
             _ExistData.FFAccountNo = r["FFAccountNo"].ToString();
             int inUnderG4 = 0;
             resp = int.TryParse(r["UnderG4"].ToString(), out inUnderG4);
             _ExistData.UnderG4 = inUnderG4;
             _ExistData.Email_OrderAcn = r["Email_OrderAcn"].ToString();
             _ExistData.Email_Invoice = r["Email_Invoice"].ToString();
             _ExistData.Email_Complain = r["Email_Complain"].ToString();
             int inNeedCustomerLogo = 0;
             resp = int.TryParse(r["NeedCustomerLogo"].ToString(), out inNeedCustomerLogo);
             _ExistData.NeedCustomerLogo = inNeedCustomerLogo;
             _ExistData.CurrenyCode = r["CurrenyCode"].ToString();
             return "True";
         }
         catch (Exception ex)
         {
             return ex.Message;
         }
     }
     else
         return "data not found ";
 }
Exemple #8
0
 public Payment(bool IsLocal)
 {
     Mycommon = new DataService(IsLocal);
 }