Example #1
0
 public IHttpActionResult FindDays(string from_date, string emp_id)
 {
     try
     {
         SqlDataReader SqlDtr;
         string        sql;
         int           leave = 0;
         sql    = "select sum(datediff(day,date_from,dateadd(day,1,'" + from_date + "'))) from leave_register where cast(floor(cast(date_from as float)) as datetime) <= '" + from_date + "' and cast(floor(cast(date_to as float)) as datetime) > '" + from_date + "'and emp_id = '" + emp_id + "' and isSanction = 1 and datepart(month,date_from) = datepart(month,'" + from_date + "')";
         SqlDtr = obj.GetRecordSet(sql);
         if (SqlDtr.HasRows)
         {
             if (SqlDtr.Read())
             {
                 if (!SqlDtr.GetValue(0).ToString().Trim().Equals(""))
                 {
                     leave += System.Convert.ToInt32(SqlDtr.GetValue(0).ToString());
                 }
             }
         }
         SqlDtr.Close();
         return(Ok(leave));
     }
     catch (Exception)
     {
         return(Content(HttpStatusCode.NotFound, "Data Not Found"));
     }
 }
Example #2
0
 public IHttpActionResult PrintSelectCase(string from_date, string Emp_id, string str1)
 {
     try
     {
         SqlDataReader SqlDtr;
         string        sql;
         int           leave = 0;
         sql    = "select case when cast(floor(cast(date_to as float)) as datetime) >= '" + from_date + "' then sum(datediff(day,'" + str1 + "',dateadd(day,1,'" + from_date + "'))) else sum(datediff(day,'" + str1 + "',dateadd(day,1,date_to))) end from leave_register where cast(floor(cast(date_from as float)) as datetime) < '" + str1 + "' and cast(floor(cast(date_to as float)) as datetime) >= '" + str1 + "'and emp_id = '" + Emp_id + "' and isSanction = 1 group by date_to";
         SqlDtr = obj.GetRecordSet(sql);
         if (SqlDtr.HasRows)
         {
             if (SqlDtr.Read())
             {
                 if (!SqlDtr.GetValue(0).ToString().Trim().Equals(""))
                 {
                     leave += System.Convert.ToInt32(SqlDtr.GetValue(0).ToString());
                 }
             }
         }
         SqlDtr.Close();
         return(Ok(leave));
     }
     catch (Exception)
     {
         return(Content(HttpStatusCode.NotFound, "Data Not Found"));
     }
 }
        // This method displays the Dealers Logo.
        public void show()
        {
            InventoryClass obj = new InventoryClass();
            SqlDataReader  SqlDtr;
            string         sql;
            string         filePath = "";

            sql    = "select Logo from Organisation where CompanyID='1001'";
            SqlDtr = obj.GetRecordSet(sql);
            if (SqlDtr.Read())
            {
                filePath = SqlDtr["Logo"].ToString();
            }
            else
            {
                string home_drive = Environment.SystemDirectory;
                home_drive = home_drive.Substring(0, 2);
                filePath   = home_drive + @"\Inetpub\wwwroot\Servosms\CompanyLogo\Logo.jpg";
            }
            if (filePath.Trim().Equals(""))
            {
                string home_drive = Environment.SystemDirectory;
                home_drive = home_drive.Substring(0, 2);
                filePath   = home_drive + @"\Inetpub\wwwroot\Servosms\CompanyLogo\Logo.jpg";
            }
            imgSample.ImageUrl = filePath;
            SqlDtr.Close();
        }
        public IHttpActionResult GetNextRoleID()
        {
            string roleID = string.Empty;

            try
            {
                #region Fetch Next Role ID
                string        sql = "select max(Role_ID)+1 from Roles";
                SqlDataReader SqlDtr;

                EmployeeClass obj = new EmployeeClass();

                SqlDtr = obj.GetRecordSet(sql);
                while (SqlDtr.Read())
                {
                    roleID = SqlDtr.GetSqlValue(0).ToString();
                }
                SqlDtr.Close();
                #endregion
                if (roleID == null)
                {
                    return(Content(HttpStatusCode.NotFound, "Failed to get Next Role ID."));
                }

                return(Ok(roleID));
            }
            catch (Exception ex)
            {
                return(Content(HttpStatusCode.NotFound, "Failed to get Next Role ID."));
            }
        }
Example #5
0
        /// <summary>
        /// This method is used to fatch the organization id from organization table and fill the
        /// dropdownlist on edit time.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button1_Click(object sender, System.EventArgs e)
        {
            CreateLogFiles Err = new CreateLogFiles();

            try
            {
                Label1.Visible = true;
                //txtFileTitle.Enabled=false;
                txtFileContents.EnableViewState = false;
                Button1.Visible         = false;
                Drop.Visible            = true;
                LblCompanyID.Visible    = false;
                txtFileContents.Visible = false;

                InventoryClass obj = new InventoryClass();
                SqlDataReader  SqlDtr;
                string         sql;

                sql    = "select max(CompanyID) from Organisation";
                SqlDtr = obj.GetRecordSet(sql);
                while (SqlDtr.Read())
                {
                    Drop.Items.Add(SqlDtr.GetValue(0).ToString());
                }
                SqlDtr.Close();
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:OrganisationDetails.aspx,Class:InventoryClass.cs ,Method:saveButton   EXCEPTION: " + ex.Message + "  User_ID: " + uid);
            }
        }
Example #6
0
        //**************
        /// <summary>
        /// This method is used to get the nextID auto.
        /// </summary>
        public void GetNextschemeID()
        {
            try
            {
                PartiesClass  obj = new PartiesClass();
                SqlDataReader SqlDtr;

                #region Fetch Next scheme ID
                SqlDtr = obj.GetNextFOID();

                while (SqlDtr.Read())
                {
                    lblschid.Text = SqlDtr.GetSqlValue(0).ToString();
                    if (lblschid.Text == "Null")
                    {
                        lblschid.Text = "100001";
                    }
                }
                SqlDtr.Close();
                #endregion
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:fleet/oe discountEntry.aspx,Class:PartiesClass.cs: Method:GetNextschemeID().  EXCEPTION " + ex.Message + "  User  " + uid);
            }
        }
Example #7
0
        public IHttpActionResult FetchCustomerNames()
        {
            InventoryClass obj = new InventoryClass();
            SqlDataReader  SqlDtr;
            string         sql;
            ArrayList      CustName = new ArrayList();

            sql    = "Select Cust_Name,city from Customer";
            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                CustName.Add(SqlDtr.GetValue(0).ToString() + ";" + SqlDtr.GetValue(1).ToString());
            }
            SqlDtr.Close();
            sql    = "Select Ledger_Name+':'+cast(Ledger_ID as varchar) Ledger_Name from Ledger_Master lm,Ledger_master_sub_grp lmsg where lm.sub_grp_id = lmsg.sub_grp_id and lmsg.sub_grp_name not like 'Bank%'  and lmsg.sub_grp_name != 'Cash in hand' and lmsg.sub_grp_name not like 'Discount%' and lmsg.sub_grp_name != 'Sundry Debtors' Order by Ledger_Name";
            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                CustName.Add(SqlDtr.GetValue(0).ToString() + "; ");
            }
            SqlDtr.Close();
            sql    = "Select Ledger_Name+':'+cast(Ledger_ID as varchar) Ledger_Name,city from Ledger_Master, Employee where Emp_Name=Ledger_Name Order by Ledger_Name";
            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                CustName.Add(SqlDtr.GetValue(0).ToString() + ";" + SqlDtr.GetValue(1).ToString());
            }
            SqlDtr.Close();
            CustName.Sort();
            if (CustName == null || CustName.Count == 0)
            {
                return(Content(HttpStatusCode.NotFound, "Customer Names Not Found"));
            }
            return(Ok(CustName));
        }
Example #8
0
        /// <summary>
        /// This method is used to generate the next user id
        /// </summary>
        public void GetNextUserID()
        {
            EmployeeClass obj = new EmployeeClass();
            SqlDataReader SqlDtr;
            string        sql;

            try
            {
                #region Fetch Next User ID

                sql    = "select max(UserID)+1 from User_Master";
                SqlDtr = obj.GetRecordSet(sql);
                while (SqlDtr.Read())
                {
                    lblUserID.Text = SqlDtr.GetSqlValue(0).ToString();
                    if (lblUserID.Text == "Null")
                    {
                        lblUserID.Text = "1001";
                    }
                }
                SqlDtr.Close();
                #endregion
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:User_Profile.aspx,Method:GetNextUserID  EXCEPTION: " + ex.Message + "    " + uid);
            }
        }
        public IHttpActionResult GetNextRouteID()
        {
            string Route_ID = string.Empty;

            try
            {
                InventoryClass obj = new InventoryClass();
                SqlDataReader  SqlDtr;
                string         sql;

                #region Fetch the Next Route ID
                sql    = "select Max(Route_ID)+1 from Route";
                SqlDtr = obj.GetRecordSet(sql);
                if (SqlDtr.Read())
                {
                    Route_ID = SqlDtr.GetValue(0).ToString();
                    if (Route_ID == "")
                    {
                        Route_ID = "1";
                    }
                }
                else
                {
                    Route_ID = "1";
                }
                SqlDtr.Close();
                #endregion
                return(Ok(Route_ID));
            }
            catch (Exception ex)
            {
                return(Content(HttpStatusCode.NotFound, "Failed to get Next Route ID"));
            }
        }
 /// <summary>
 /// This method fetch the beat related information and put into the textboxes.
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void DropBeatNo_SelectedIndexChanged(object sender, System.EventArgs e)
 {
     try
     {
         if (DropBeatNo.SelectedIndex == 0)
         {
             return;
         }
         PartiesClass  obj = new PartiesClass();
         SqlDataReader SqlDtr;
         string        sql;
         string        cty = DropBeatNo.SelectedItem.Value;
         string[]      arr = cty.Split(new char[] { ':' }, cty.Length);
         //sql="Select * from Beat_Master where Beat_No='"+ DropBeatNo.SelectedItem.Value  +"'";
         sql    = "Select * from Beat_Master where Beat_No='" + arr[0] + "'";
         SqlDtr = obj.GetRecordSet(sql);
         while (SqlDtr.Read())
         {
             txtCity.Text    = SqlDtr.GetValue(1).ToString();
             txtState.Text   = SqlDtr.GetValue(2).ToString();
             txtCountry.Text = SqlDtr.GetValue(3).ToString();
         }
         SqlDtr.Close();
         CreateLogFiles.ErrorLog("Form:BeatMasterEntery.aspx,Method:DropBeatNo_SelectedIndexChanged" + uid);
     }
     catch (Exception ex)
     {
         CreateLogFiles.ErrorLog("Form:BeatMasterEntery.aspx,Method:DropBeatNo_SelectedIndexChange" + "  EXCEPTION " + ex.Message + uid);
     }
 }
Example #11
0
        /// <summary>
        /// This method is used to fatch the Customer name with type and fill the list.
        /// and also fatch the product name with pack type and fill the list.
        /// </summary>
        public void getCustandProd()
        {
            InventoryClass obj = new InventoryClass();
            SqlDataReader  SqlDtr;
            string         sql;

            //sql="select cust_Name, cust_Name + ':' + cust_type  from customer  where cust_type='Fleet' or cust_type like('Oe%')  order by cust_Name";
            sql    = "select cust_Name, cust_Name + ':' + cust_type  from customer where cust_type like'Oe%' order by cust_Name";
            SqlDtr = obj.GetRecordSet(sql);
            ListEmpAvailable.Items.Clear();
            while (SqlDtr.Read())
            {
                ListEmpAvailable.Items.Add(SqlDtr.GetValue(1).ToString());
            }
            SqlDtr.Close();

            //*********************************
            sql    = "select prod_Name, prod_Name + ':' + pack_type  from products  order by prod_Name";
            SqlDtr = obj.GetRecordSet(sql);
            Listprodavail.Items.Clear();
            while (SqlDtr.Read())
            {
                Listprodavail.Items.Add(SqlDtr.GetValue(1).ToString());
            }
            SqlDtr.Close();
            //***********************************
        }
        /// <summary>
        /// This is used fill all ID's in dropdown.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnEdit_Click(object sender, System.EventArgs e)
        {
            DropBeatNo.Visible       = true;
            btnEdit.Visible          = false;
            Edit1.Visible            = true;
            Edit1.Enabled            = true;
            btnDelete.Enabled        = true;
            btnSave.CausesValidation = false;
            lblBeatNo.Visible        = false;

            //
            Clear();
            try
            {
                PartiesClass  obj = new PartiesClass();
                SqlDataReader SqlDtr;
                SqlDtr = obj.GetRecordSet("select Beat_No,city from Beat_Master order by city");
                DropBeatNo.Items.Clear();
                DropBeatNo.Items.Add("Select");
                while (SqlDtr.Read())
                {
                    DropBeatNo.Items.Add(SqlDtr.GetValue(0).ToString() + ':' + SqlDtr.GetValue(1).ToString());
                }
                SqlDtr.Close();
                checkPrevileges();
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:BeatMasterEntery.aspx,Method:btnEdit_Click().  EXCEPTION " + ex.Message + "  " + uid);
            }
        }
        public IHttpActionResult fillCombo2()
        {
            SqlDataReader SqlDtr;
            List <string> DropBy = new List <string>();

            string sql, str, strCash;

            strCash = "";
            sql     = "Select Ledger_Name,sub_grp_name from Ledger_Master lm,Ledger_master_sub_grp lmsg  where  lm.sub_grp_id = lmsg.sub_grp_id  and (sub_grp_name='Cash in hand' or sub_grp_name like'Bank%')  Order by Ledger_Name";
            SqlDtr  = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                str = SqlDtr["sub_grp_name"].ToString();
                if (str.Equals("Cash in hand") || str.IndexOf("Bank") > -1)
                {
                    DropBy.Add(SqlDtr["Ledger_Name"].ToString());
                    if (str.Equals("Cash in hand"))
                    {
                        strCash = SqlDtr["Ledger_Name"].ToString();
                    }
                }
            }
            SqlDtr.Close();
            payment.DropBy1 = DropBy;
            payment.strCash = strCash;
            if (payment.Equals(0) || payment == null)
            {
                return(Content(HttpStatusCode.NotFound, "Data Not Found"));
            }
            return(Ok(payment));
        }
        public IHttpActionResult DeletePayment(string CustName, string VoucherId)
        {
            SqlDataReader SqlDtr;
            string        sql = "select Cust_id from Customer where Cust_Name='" + CustName + "' ";

            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                payment.CustId = SqlDtr.GetValue(0).ToString();
            }
            SqlDtr.Close();
            sql    = "delete from payment_transaction where voucher_id = '" + VoucherId + "'";
            SqlDtr = obj.GetRecordSet(sql);
            SqlDtr.Close();
            sql    = "delete from AccountsLedgerTable where Particulars = 'Payment (" + VoucherId + ")'";
            SqlDtr = obj.GetRecordSet(sql);
            SqlDtr.Close();
            if (payment.CustId != "")
            {
                sql = "delete from CustomerLedgerTable where Particular = 'Voucher(" + VoucherId + ")'";
            }
            if (payment.Equals(0) || payment == null)
            {
                return(Content(HttpStatusCode.NotFound, "Payment Not Deleted"));
            }
            return(Ok(payment));
        }
        public IHttpActionResult SelectCustId(string Ledger_ID1, string OldLedger_ID)
        {
            SqlDataReader SqlDtr;
            string        sql = "select Cust_ID from Customer,Ledger_Master where Ledger_Name = Cust_Name and Ledger_ID ='" + Ledger_ID1 + "' ";

            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                payment.Ledger_ID1 = SqlDtr["Cust_ID"].ToString();
            }
            SqlDtr.Close();

            sql    = "select Cust_ID from Customer,Ledger_Master where Ledger_Name = Cust_Name and Ledger_ID ='" + OldLedger_ID + "' ";
            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                payment.OldLedger_ID = SqlDtr["Cust_ID"].ToString();
            }
            SqlDtr.Close();
            if (payment.Equals(0) || payment == null)
            {
                return(Content(HttpStatusCode.NotFound, "Customer ID Not Found"));
            }
            return(Ok(payment));
        }
Example #16
0
    public string GetInvoiceNo1()
    {
        //int no = 0;
        string InNo = "";

        try
        {
            InventoryClass obj = new InventoryClass();
            SqlDataReader  SqlDtr;
            string         sql;
            sql    = "select max(Invoice_No) from Purchase_Master";
            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                InNo = SqlDtr.GetValue(0).ToString();
                //no = Int32.Parse(InNo);
                //no = no + 1;
            }
            SqlDtr.Close();
            //InNo = no.ToString();
            return(InNo);
        }
        catch (Exception)
        {
            return(InNo);

            throw;
        }
    }
        //This is used to generate ID auto.
        private void fillID()
        {
            SqlConnection con;
            SqlCommand    cmd;

            try
            {
                con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]);
                con.Open();
                SqlDataReader SqlDtr;

                cmd    = new SqlCommand("select max(customermechid)+1 from Customermechanicentry", con);
                SqlDtr = cmd.ExecuteReader();

                if (SqlDtr.HasRows)
                {
                    while (SqlDtr.Read())
                    {
                        txtcustid.Text = SqlDtr.GetValue(0).ToString();
                        if (txtcustid.Text.Trim().Equals(""))
                        {
                            txtcustid.Text = "1";
                        }
                    }
                }


                SqlDtr.Close();
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// This method is used to generate next CustomerTypeID from CustomerType table
        /// and fill in the textbox when page is loaded.
        /// </summary>
        private void fillID()
        {
            SqlConnection con;
            SqlCommand    cmd;

            try
            {
                con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]);
                con.Open();
                SqlDataReader SqlDtr;
                cmd    = new SqlCommand("select max(CustomerTypeID)+1 from CustomerType", con);
                SqlDtr = cmd.ExecuteReader();
                if (SqlDtr.HasRows)
                {
                    while (SqlDtr.Read())
                    {
                        txtid.Text = SqlDtr.GetValue(0).ToString();
                        if (txtid.Text.Trim().Equals(""))
                        {
                            txtid.Text = "1";
                        }
                    }
                }
                SqlDtr.Close();
                con.Close();
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:CustomerType.aspx,Method:FillID, EXCEPTION " + ex.Message + "  userid  " + uid);
                MessageBox.Show(ex.Message);
            }
        }
        public IHttpActionResult SeqStockMaster(string str1)
        {
            try
            {
                SqlDataReader        SqlDtr;
                StockAdjustmentModel stkadj = new StockAdjustmentModel();
                string sql;
                sql    = "select * from Stock_Master where Productid='" + str1 + "' order by Stock_date";
                SqlDtr = obj.GetRecordSet(sql);
                while (SqlDtr.Read())
                {
                    controlopening_stock.Add(SqlDtr["opening_stock"].ToString());
                    controlreceipt.Add(SqlDtr["receipt"].ToString());
                    controlsales.Add(SqlDtr["sales"].ToString());
                    controlsalesfoc.Add(SqlDtr["salesfoc"].ToString());
                    controlProductid.Add(SqlDtr["Productid"].ToString());
                    controlstock_date.Add(SqlDtr["stock_date"].ToString());
                }
                SqlDtr.Close();

                stkadj.opening_stock = controlopening_stock;
                stkadj.receipt       = controlreceipt;
                stkadj.sales         = controlsales;
                stkadj.salesfoc      = controlsalesfoc;
                stkadj.Productid     = controlProductid;
                stkadj.stock_date    = controlstock_date;
                return(Ok(stkadj));
            }
            catch (Exception ex)
            {
                return(Content(HttpStatusCode.NotFound, "Route could not update."));
            }
        }
 public IHttpActionResult GetNextOTID()
 {
     try
     {
         SqlDataReader SqlDtr;
         string        sql, nextid = "";
         sql    = "select max(OT_ID) from OverTime_Register";
         SqlDtr = obj.GetRecordSet(sql);
         while (SqlDtr.Read())
         {
             if (nextid == null || nextid == "")
             {
                 nextid = SqlDtr.GetValue(0).ToString();
             }
             else
             {
                 nextid = "1";
             }
         }
         SqlDtr.Close();
         return(Ok(nextid));
     }
     catch (Exception)
     {
         return(Content(HttpStatusCode.NotFound, "Data Not Found"));
     }
 }
Example #21
0
 public string GetNextPeriodID()
 {
     try
     {
         Next_Period_Id = "1";
         InventoryClass obj = new InventoryClass();
         SqlDataReader  SqlDtr;
         string         sql = " Select max(Period_Id)+1 Next_Id from Cust_Sale_MS_HSD";
         SqlDtr = obj.GetRecordSet(sql);
         while (SqlDtr.Read())
         {
             if (SqlDtr["Next_Id"].ToString() != null && SqlDtr["Next_Id"].ToString() != "")
             {
                 Next_Period_Id = SqlDtr["Next_Id"].ToString();
             }
             else
             {
                 Next_Period_Id = "1";
             }
         }
         SqlDtr.Close();
         return(Next_Period_Id);
     }
     catch (Exception ex)
     {
         return(Next_Period_Id);
     }
 }
        /// <summary>
        /// This method is used to fatch the ssr information from employee table and also fatch the
        /// city from beat Master table and fill into the dropdownlist.
        /// </summary>
        public void FillList()
        {
            try
            {
                InventoryClass obj = new InventoryClass();
                SqlDataReader  SqlDtr;
                string         sql = "select emp_name from employee where Designation='Servo Sales Representative' order by emp_name";
                SqlDtr = obj.GetRecordSet(sql);
                DropSSRname.Items.Clear();
                DropSSRname.Items.Add("Select");;
                while (SqlDtr.Read())
                {
                    DropSSRname.Items.Add(SqlDtr.GetValue(0).ToString());
                }
                SqlDtr.Close();

                sql    = "select city from beat_master order by city";
                SqlDtr = obj.GetRecordSet(sql);
                Listbeat.Items.Clear();
                while (SqlDtr.Read())
                {
                    Listbeat.Items.Add(SqlDtr.GetValue(0).ToString());
                }
                SqlDtr.Close();
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form : SelesPersionAssignment.aspx,Method : FillList()" + ex.Message + "  EXCEPTION  " + uid);
            }
        }
Example #23
0
        protected void Page_Load(object sender, System.EventArgs e)
        {
            try
            {
                string check = "";
                Cal_Img1.Visible = false;

                // check string gets the value from the check() method present in Security.dll;
                check = MySecurity.MySecurity.check();
                // If the return value is false then the activation period expired and redirect to the error.aspx
                if (check.Equals("false"))
                {
                    Response.Redirect("..\\Sysitem\\error.aspx", false);
                    return;
                }
                // If the return value is Service then the Print_WindowsService is stopped and redirect to the Service.aspx
                if (check.Equals("Service"))
                {
                    Response.Redirect("..\\Sysitem\\Service.aspx", false);
                    return;
                }

                // If the return value is starts with P then dispaly the activation period.
                if (!check.Equals(""))
                {
                    if (!check.Equals("true") && check.StartsWith("P"))
                    {
                        lblMessage.Text   = check.Substring(1) + " left for Activation";
                        Cal_Img.Disabled  = true;
                        Cal_Img.Visible   = false;
                        Cal_Img1.Visible  = true;
                        Cal_Img1.Disabled = true;
                    }
                }
                Session.Clear();
                if (!IsPostBack)
                {
                    PetrolPumpClass obj = new PetrolPumpClass();
                    SqlDataReader   SqlDtr;
                    string          sql;
                    // Fetch the roles and fills the User Type combo.
                    sql    = "select Role_Name from Roles";
                    SqlDtr = obj.GetRecordSet(sql);

                    while (SqlDtr.Read())
                    {
                        DropUser.Items.Add(SqlDtr.GetValue(0).ToString());
                    }
                    SqlDtr.Close();
                    txtSetDate.Text = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                MessageBox.Show(ex.StackTrace);
            }
        }
        /// <summary>
        /// this method is used to fatch the CustomerTypeName and CustomerTypeID from CustomerType table
        /// and fill the textboxes.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void dropid_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            try
            {
                //add by vikas sharma 23.10.2012

                if (dropid.SelectedIndex == 0)
                {
                    txtname.Text             = "";
                    dropGroup.SelectedIndex  = 0;
                    dropSGroup.SelectedIndex = 0;
                    return;
                }

                btnEdit.Text      = "Update";
                btnEdit.Enabled   = true;
                btnDelete.Enabled = true;
                //dropid.Visible=true;
                SqlCommand    cmd;
                SqlConnection con;
                con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]);
                con.Open();
                SqlDataReader SqlDtr;
                //	*		cmd=new SqlCommand("select * from CustomerType where CustomerTypeID='"+dropid.SelectedItem.Text.ToString()+"'",con);
                cmd    = new SqlCommand("select * from CustomerType where CustomerTypeName='" + dropid.SelectedItem.Text.Trim().ToString() + "'", con);
                SqlDtr = cmd.ExecuteReader();
                while (SqlDtr.Read())
                {
                    txtid.Text               = SqlDtr.GetValue(0).ToString();
                    txtname.Text             = SqlDtr.GetValue(1).ToString();
                    dropGroup.SelectedIndex  = dropGroup.Items.IndexOf(dropGroup.Items.FindByText(SqlDtr.GetValue(2).ToString()));                         //Add by Vikas Sharma 23.10.2012
                    dropSGroup.SelectedIndex = dropSGroup.Items.IndexOf(dropSGroup.Items.FindByText(SqlDtr.GetValue(3).ToString()));                       //Add by Vikas Sharma 23.10.2012
                }
                Object Add_Flag  = Cache["Add"];
                Object Edit_Flag = Cache["Edit"];
                Object Del_Flag  = Cache["Del"];
                if (System.Convert.ToString(Add_Flag) == "0")
                {
                    btnAdd.Enabled = false;
                }
                if (System.Convert.ToString(Edit_Flag) == "0")
                {
                    btnEdit.Enabled = false;
                }
                if (System.Convert.ToString(Del_Flag) == "0")
                {
                    btnDelete.Enabled = false;
                }
                CreateLogFiles.ErrorLog("Form:CustomerType.aspx,Method:Dropid_SelectedIndexChange, userid  " + uid);
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:CustomerType.aspx,Method:Dropid_SelectedIndexChange,   EXCEPTION " + ex.Message + "  userid  " + uid);
            }
        }
Example #25
0
        public string GetBackOrderNo(string Order_No, string Prod_id, string cust_id)
        {
            try
            {
                BO_No = "0";
                InventoryClass obj = new InventoryClass();
                SqlDataReader  SqlDtr;
                string         sql = "";
                sql    = " select distinct bo_1,bo_2,bo_3 from ovd where cast(item_qty as float)>cast(sale_qty as float) and Order_id=" + Order_No.ToString() + " and item_id=" + Prod_id.ToString() + " and cust_id=" + cust_id.ToString();
                SqlDtr = obj.GetRecordSet(sql);
                while (SqlDtr.Read())
                {
                    if (SqlDtr["Bo_3"].ToString() == null || SqlDtr["Bo_3"].ToString() == "")
                    {
                        if (SqlDtr["Bo_2"] == null || SqlDtr["Bo_2"].ToString() == "")
                        {
                            if (SqlDtr["Bo_1"].ToString() == null || SqlDtr["Bo_1"].ToString() == "")
                            {
                                BO_No = "0";
                            }
                            else
                            {
                                if (SqlDtr["Bo_1"].ToString() != null && SqlDtr["Bo_1"].ToString() != "")
                                {
                                    BO_No = "BO:" + SqlDtr["Bo_1"].ToString();
                                }
                            }
                        }
                        else
                        {
                            if (SqlDtr["Bo_2"].ToString() != null && SqlDtr["Bo_2"].ToString() != "")
                            {
                                BO_No = "BO:" + SqlDtr["Bo_2"].ToString();
                            }
                        }
                    }
                    else
                    {
                        if (SqlDtr["Bo_3"].ToString() != null && SqlDtr["Bo_3"].ToString() != "")
                        {
                            BO_No = "BO:" + SqlDtr["Bo_3"].ToString();
                        }
                    }
                }
                SqlDtr.Close();
                return(BO_No.ToString());
            }
            catch (Exception ex)
            {
                return(BO_No.ToString());

                CreateLogFiles.ErrorLog(" Form : BackOrder_Report.aspx , Method : GetOrderInvoice,   Exception : " + ex.Message + " user : " + uid);
            }
        }
Example #26
0
        public string GetBackOrderDate(string Order_No, string Prod_id, string cust_id)
        {
            try
            {
                BO_Date = "0";
                InventoryClass obj = new InventoryClass();
                SqlDataReader  SqlDtr;
                string         sql = "";
                sql    = " select distinct Date_Bo_1,Date_Bo_2,Date_Bo_3 from ovd where item_qty > sale_qty and Order_id=" + Order_No.ToString() + " and item_id=" + Prod_id.ToString() + " and cust_id=" + cust_id.ToString();
                SqlDtr = obj.GetRecordSet(sql);
                while (SqlDtr.Read())
                {
                    if (SqlDtr["Date_Bo_3"].ToString() == null || SqlDtr["Date_Bo_3"].ToString() == "")
                    {
                        if (SqlDtr["Date_Bo_2"] == null || SqlDtr["Date_Bo_2"].ToString() == "")
                        {
                            if (SqlDtr["Date_Bo_1"].ToString() == null || SqlDtr["Date_Bo_1"].ToString() == "")
                            {
                                BO_Date = "0";
                            }
                            else
                            {
                                if (SqlDtr["Date_Bo_1"].ToString() != null && SqlDtr["Date_Bo_1"].ToString() != "")
                                {
                                    BO_Date = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr["Date_Bo_1"].ToString()));
                                }
                            }
                        }
                        else
                        {
                            if (SqlDtr["Date_Bo_2"].ToString() != null && SqlDtr["Date_Bo_2"].ToString() != "")
                            {
                                BO_Date = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr["Date_Bo_2"].ToString()));
                            }
                        }
                    }
                    else
                    {
                        if (SqlDtr["Date_Bo_3"].ToString() != null && SqlDtr["Date_Bo_3"].ToString() != "")
                        {
                            BO_Date = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr["Date_Bo_3"].ToString()));
                        }
                    }
                }
                SqlDtr.Close();
                return(BO_Date.ToString());
            }
            catch (Exception ex)
            {
                return(BO_Date.ToString());

                CreateLogFiles.ErrorLog(" Form : HSD_MS_Report.aspx , Method : GetOrderInvoice,   Exception : " + ex.Message + " user : " + uid);
            }
        }
Example #27
0
        /// <summary>
        /// This method is used to fatch the all market customer id from database table
        /// and fill this value into the dropdownlist.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnselect_Click(object sender, System.EventArgs e)
        {
            SqlConnection con;
            SqlCommand    cmd;

            try
            {
                con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]);
                con.Open();
                SqlDataReader SqlDtr;

                cmd    = new SqlCommand("select mcid from marketCustomerentry1", con);
                SqlDtr = cmd.ExecuteReader();
                dropid.Items.Clear();
                dropid.Items.Add("select");

                if (SqlDtr.HasRows)
                {
                    while (SqlDtr.Read())
                    {
                        dropid.Items.Add(SqlDtr.GetValue(0).ToString());
                    }
                }

                dropid.Visible    = true;
                btnselect.Visible = false;
                btnadd.Enabled    = false;
                SqlDtr.Close();
                con.Close();
                Object Add_Flag  = Cache["Add"];
                Object Edit_Flag = Cache["Edit"];
                Object Del_Flag  = Cache["Del"];
                if (System.Convert.ToString(Add_Flag) == "0")
                {
                    btnadd.Enabled = false;
                }
                if (System.Convert.ToString(Edit_Flag) == "0")
                {
                    btnedit.Enabled = false;
                }
                if (System.Convert.ToString(Del_Flag) == "0")
                {
                    btndelete.Enabled = false;
                }
                CreateLogFiles.ErrorLog("Form:MarketCustEntry.aspx,Method:btnSelect, Userid= " + uid);
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:MarketCustEntry.aspx,Method:btnSelect" + "  EXCEPTION " + ex.Message + "Userid= " + uid);
                MessageBox.Show(ex.Message);
            }
        }
Example #28
0
		/// <summary>
		/// This method is used to fatch the all product name with pack type and fill in list.
		/// </summary>
		public void FillList()
		{
			InventoryClass obj = new InventoryClass();
			SqlDataReader SqlDtr;
			string sql="select prod_Name, prod_Name + ':' + pack_type  from products  where unit!='Nos.' order by prod_Name";
			SqlDtr = obj.GetRecordSet (sql);
			ListEmpAvailable.Items.Clear();
			while(SqlDtr.Read ())
			{
				ListEmpAvailable.Items.Add(SqlDtr.GetValue(1).ToString ());
			}
			SqlDtr.Close();
		}
Example #29
0
        /// <summary>
        /// This method is used to Displays the Organisation details information on edit time.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Drop_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            try
            {
                txtdumy.Text = Drop.SelectedItem.Value.ToString();
                if (txtdumy.Text == "Select")
                {
                    MessageBox.Show("Please Select Company ID ");
                }
                else
                {
                    InventoryClass obj = new InventoryClass();
                    SqlDataReader  SqlDtr;
                    string         sql;

                    sql    = "select * from Organisation where CompanyID='" + Drop.SelectedItem.Value + "'";
                    SqlDtr = obj.GetRecordSet(sql);
                    while (SqlDtr.Read())
                    {
                        txtDealerName.Text           = SqlDtr.GetValue(1).ToString();
                        DropDealerShip.SelectedIndex = (DropDealerShip.Items.IndexOf((DropDealerShip.Items.FindByValue(SqlDtr.GetValue(2).ToString()))));
                        TxtAddress.Text           = SqlDtr.GetValue(3).ToString();
                        DropCity.SelectedIndex    = (DropCity.Items.IndexOf((DropCity.Items.FindByValue(SqlDtr.GetValue(4).ToString()))));
                        DropState.SelectedIndex   = (DropState.Items.IndexOf((DropState.Items.FindByValue(SqlDtr.GetValue(5).ToString()))));
                        DropCountry.SelectedIndex = (DropCountry.Items.IndexOf((DropCountry.Items.FindByValue(SqlDtr.GetValue(6).ToString()))));
                        txtPhoneOff.Text          = SqlDtr.GetValue(7).ToString();
                        TxtFaxNo.Text             = SqlDtr.GetValue(8).ToString();
                        txtEMail.Text             = SqlDtr.GetValue(9).ToString();
                        TxtWebsite.Text           = SqlDtr.GetValue(10).ToString();
                        TxtTinno.Text             = SqlDtr.GetValue(11).ToString();

                        txtentry.Text = SqlDtr.GetValue(12).ToString();
                        txtfood.Text  = SqlDtr.GetValue(13).ToString();
                        TxtWMlic.Text = SqlDtr.GetValue(14).ToString();
                        dropstateoffice.SelectedIndex = (dropstateoffice.Items.IndexOf((dropstateoffice.Items.FindByValue(SqlDtr.GetValue(16).ToString()))));
                        txtFileContents.Name          = SqlDtr.GetValue(15).ToString();
                        txtMsg.Text            = SqlDtr.GetValue(17).ToString();
                        txtVatRate.Text        = GenUtil.strNumericFormat(SqlDtr.GetValue(18).ToString().Trim());
                        txtDateFrom.Text       = checkDate(GenUtil.str2DDMMYYYY(trimDate(SqlDtr.GetValue(19).ToString().Trim())));
                        txtDateTo.Text         = checkDate(GenUtil.str2DDMMYYYY(trimDate(SqlDtr.GetValue(20).ToString().Trim())));
                        txtStartInvoiceNo.Text = SqlDtr.GetValue(21).ToString();
                    }
                    SqlDtr.Close();
                }
            }
            catch (Exception ex)
            {
                CreateLogFiles.ErrorLog("Form:OrganisationDetails.aspx,Class:InventoryClass.cs ,Method:Drop_SelectedIndexChanged(). EXCEPTION: " + ex.Message + ".   userid " + uid);
            }
        }
        public string SaveAttandance(string Att_Date, string lblEmpID)
        {
            string        str = "";
            SqlDataReader SqlDtr;
            string        sql = "select Status from Attandance_Register where Att_Date='" + Att_Date + "' and  Emp_ID=" + lblEmpID + "";

            SqlDtr = obj.GetRecordSet(sql);
            while (SqlDtr.Read())
            {
                str = SqlDtr.GetValue(0).ToString();
            }
            SqlDtr.Close();
            return(str);
        }