예제 #1
0
 public IEnumerable <string> GetSerialNames(IEnumerable <Guid> guids, bool deleted)
 {
     using (LinqDataContext l = new LinqDataContext())
     {
         return(l.СерийныйНомерs.Where(w => guids.Contains(w.Oid) && (!deleted ? w.GCRecord == null : w.GCRecord != null)).Select(s => s.Номер).ToList());
     }
 }
예제 #2
0
 public IEnumerable <string> GetConsignmentNames(IEnumerable <Guid> guids, bool deleted)
 {
     using (LinqDataContext l = new LinqDataContext())
     {
         return(l.СпецификацияПартияs.Where(w => guids.Contains(w.Oid) && (!deleted ? w.GCRecord == null : w.GCRecord != null)).Select(s => s.Партия).ToList());
     }
 }
예제 #3
0
 public IEnumerable <string> GetNomenclatureNames(IEnumerable <Guid> guids, bool deleted)
 {
     using (LinqDataContext l = new LinqDataContext())
     {
         return(l.НоменклатурнаяПозицияs.Where(w => guids.Contains(w.Oid) && (!deleted ? w.GCRecord == null : w.GCRecord != null)).Select(s => s.СтроковоеПредставление).ToList());
     }
 }
예제 #4
0
        public MyObservableCollection <Inmueble> GetInmuebles()
        {
            hasError = false;
            MyObservableCollection <Inmueble> inmueble = new MyObservableCollection <Inmueble>();

            try
            {
                LinqDataContext dc    = new LinqDataContext();
                var             query = from q in dc.LinqProducts
                                        select new SqlInmueble {
                    InmuebleId  = q.ProductID, Direccion = q.ModelNumber,
                    Vendedor    = q.ModelName, Precio = (decimal)q.UnitCost,
                    Descripcion = q.Description, Categoria = q.LinqCategory.CategoryName
                };
                foreach (SqlInmueble sp in query)
                {
                    inmueble.Add(sp.SqlProduct2Product());
                }
            }
            catch (Exception ex)
            {
                errorMessage = "GetInmuebles() error, " + ex.Message;
                hasError     = true;
            }
            return(inmueble);
        }
예제 #5
0
        static void Main()
        {
            string columnToGroupBy = "Size";

            // generate the dynamic Expression<Func<Product, string>>
            ParameterExpression p = Expression.Parameter(typeof(Product), "p");

            var selector = Expression.Lambda <Func <Product, string> >(
                Expression.Property(p, columnToGroupBy),
                p
                );

            using (LinqDataContext dataContext = new LinqDataContext())
            {
                /* using "selector" caluclated above which is automatically
                 * compiled when the query runs */
                var results = dataContext
                              .Products
                              .GroupBy(selector)
                              .Select((group) => new {
                    Key   = group.Key,
                    Count = group.Count()
                });

                foreach (var result in results)
                {
                    Console.WriteLine("{0}: {1}", result.Key, result.Count);
                }
            }

            Console.ReadKey();
        }
예제 #6
0
        public static void EndMissionDate()
        {
            var bank = new LinqDataContext();

            var query = from p in bank.sarbazs
                        where p.مدت_ماموریت_ماه_ != null
                        select p;

            foreach (var items in query)
            {
                PersianCalendar pcalender = new PersianCalendar();

                DateTime date = pcalender.ToDateTime(Convert.ToDateTime(items.تاریخ_اعزام).Year,
                                                     Convert.ToDateTime(items.تاریخ_اعزام).Month,
                                                     Convert.ToDateTime(items.تاریخ_اعزام).Day, 0, 0, 0, 0, 0
                                                     );
                var x = items.مدت_ماموریت_ماه_;
                if (x == "" || x == null)
                {
                    x = "0";
                }
                DateTime date_EndMission = date.AddMonths(Convert.ToInt32(x));
                items.تاریخ_اتمام_ماموریت = pcalender.GetYear(date_EndMission) + "/" +
                                            pcalender.GetMonth(date_EndMission) + "/" +
                                            pcalender.GetDayOfMonth(date_EndMission);
            }
            //   return date_EndMission;
            bank.SubmitChanges();
        }
예제 #7
0
 public IEnumerable <string> GetDocumentNames(IEnumerable <Guid> guids, bool deleted)
 {
     using (LinqDataContext l = new LinqDataContext())
     {
         return(l.Документs.Where(w => guids.Contains(w.Oid) && (!deleted ? w.GCRecord == null : w.GCRecord != null)).Select(s => s.СтроковоеПредставление).ToList());
     }
 }
예제 #8
0
        public ProductObservableCollection <Product> GetProducts()
        {
            hasError = false;
            ProductObservableCollection <Product> products = new ProductObservableCollection <Product>();

            try
            {
                LinqDataContext dc    = new LinqDataContext();
                var             query = from q in dc.LinqProducts
                                        select new ProductModel
                {
                    ProductId    = q.ProductID,
                    ModelNumber  = q.ModelNumber,
                    ModelName    = q.ModelName,
                    UnitCost     = (decimal)q.UnitCost,
                    Description  = q.Description,
                    CategoryName = q.LinqCategory.CategoryName
                };
                foreach (ProductModel sp in query)
                {
                    products.Add(sp.ProductModel2Product());
                }
            } //try
            catch (Exception ex)
            {
                errorMessage = "GetProducts() error, " + ex.Message;
                hasError     = true;
            }

            return(products);
        } //GetProducts()
예제 #9
0
 public static LinqDataContext getLinqContext()
 {
     if (Linq == null)
     {
         Linq = new LinqDataContext();
     }
     return(Linq);
 }
예제 #10
0
        public static bool checkEmailDoanvien(int ID, string email)
        {
            LinqDataContext db = new LinqDataContext();
            var             dt = (from a in db.DoanViens
                                  where a.ID != ID && a.Email.Trim() == email
                                  select a).Count();

            return(dt == 0);
        }
예제 #11
0
        public string[] getStaffList(string prefixText, int count)
        {
            LinqDataContext db     = new LinqDataContext();
            var             result = from u in db.TBDS_STAFFINFOs
                                     where u.ST_CODE.StartsWith(prefixText)
                                     select u.ST_CODE + " " + u.ST_NAME;

            result = result.Take <string>(count);
            string[] stufflist = result.ToArray <string>();
            return(stufflist);
        }
예제 #12
0
        public string[] getWarehouseList(string prefixText, int count)
        {
            LinqDataContext db     = new LinqDataContext();
            var             result = from u in db.TBWS_WAREHOUSEINFOs
                                     where u.WS_ID.StartsWith(prefixText)
                                     select u.WS_ID + " " + u.WS_NAME;

            result = result.Take <string>(count);
            string[] warehouselist = result.ToArray <string>();
            return(warehouselist);
        }
예제 #13
0
        public string[] getSupplierList(string prefixText, int count)
        {
            LinqDataContext db     = new LinqDataContext();
            var             result = from u in db.TBCS_CUSUPINFOs
                                     where u.CS_HRCODE.StartsWith(prefixText)
                                     select u.CS_CODE + " " + u.CS_NAME;

            result = result.Take <string>(count);
            string[] supplierlist = result.ToArray <string>();
            return(supplierlist);
        }
예제 #14
0
        private void FrmApply_M_Load(object sender, EventArgs e)
        {
            var bank  = new LinqDataContext();
            var query = (from p in bank.Gradetbls
                         orderby p.Id_Grade
                         select new { p.Id_Grade, p.Grade }).Distinct();

            comboBox_Grade.DataSource    = query;
            comboBox_Grade.DisplayMember = "Grade";
            comboBox_Grade.ValueMember   = "Id_Grade";
        }
예제 #15
0
        public Controller()
        {
            memLinq = new LinqDataContext();
            swLog   = MemLinq.Log as StreamWriter;
            string sICol3Max = global::VNTSellGold.Properties.Resources.ICol3Max;

            if (!string.IsNullOrEmpty(sICol3Max))
            {
                iCol3Tbl5Max = Convert.ToInt32(sICol3Max);
            }
        }
예제 #16
0
        public string[] getDepList(string prefixText, int count)
        {
            LinqDataContext db     = new LinqDataContext();
            var             result = from u in db.TBDS_DEPINFOs
                                     where u.DEP_CODE.StartsWith(prefixText)
                                     select u.DEP_CODE + " " + u.DEP_NAME;

            result = result.Take <string>(count);
            string[] deplist = result.ToArray <string>();
            return(deplist);
        }
예제 #17
0
        public static void FreeDate()
        {
            var bank = new LinqDataContext();

            var query = from p in bank.sarbazs
                        //   where p.Id_Sarbaz == Id_sarbaz
                        select p;

            foreach (var items in query)
            {
                var x = items.مدت_كسر_خدمت_به_روز;
                var y = items.خدمت_قبلی_روز;
                var z = items.مدت_اضافه_خدمت_روز;
                if (x == "" || x == null)
                {
                    x = "0";
                }
                if (y == "" || y == null)
                {
                    y = "0";
                }
                if (z == "" || z == null)
                {
                    z = "0";
                }
                int Day_variable = -Convert.ToInt32(x)
                                   - Convert.ToInt32(y)
                                   + Convert.ToInt32(z);
                PersianCalendar pcalender = new PersianCalendar();
                PersianDate     pDateObj  = new PersianDate();

                int year  = Convert.ToDateTime(items.تاریخ_اعزام).Year;
                int month = Convert.ToDateTime(items.تاریخ_اعزام).Month;
                int day   = Convert.ToDateTime(items.تاریخ_اعزام).Day;

                pDateObj.increasePersianMonth(ref year, ref month, 21);



                DateTime date = pcalender.ToDateTime(year,
                                                     month,
                                                     day, 0, 0, 0, 0, 0
                                                     );
                //  DateTime date_FreeDate = date.AddMonths(21);
                DateTime date_FreeDate1 = date.AddDays(Day_variable);
                items.تاریخ_ترخیص = pcalender.GetYear(date_FreeDate1) + "/" +
                                    pcalender.GetMonth(date_FreeDate1) + "/" +
                                    pcalender.GetDayOfMonth(date_FreeDate1);
            }
            //return date_FreeDate;
            bank.SubmitChanges();
        }
예제 #18
0
 public bool UpdateInmueble(Inmueble mostrarInmueble)
 {
     try
     {
         SqlInmueble     inmueble = new SqlInmueble(mostrarInmueble);
         LinqDataContext dc       = new LinqDataContext();
         dc.UpdateInmueble(inmueble.InmuebleId, inmueble.Categoria, inmueble.Direccion, inmueble.Vendedor, inmueble.Precio, inmueble.Descripcion);
     }
     catch (Exception ex)
     {
         errorMessage = "Update error, " + ex.Message;
         hasError     = true;
     }
     return(!hasError);
 }
예제 #19
0
        } //GetProducts()

/*
 *      private string GetStringOrNull(SqlDataReader reader, string columnName)
 *      {
 *          return reader.IsDBNull(reader.GetOrdinal(columnName)) ? "" : (string)reader[columnName];
 *      }
 */

        /*
         * private const int prodStringLen = 50;
         * public bool UpdateProduct(Product displayP)
         * {
         *  SqlProduct p = new SqlProduct( displayP);
         *  hasError = false;
         *  SqlConnection con = new SqlConnection(conString);
         *  SqlCommand cmd = new SqlCommand("UpdateProduct", con);
         *  cmd.CommandType = CommandType.StoredProcedure;
         *  cmd.Parameters.Add("@ProductId", SqlDbType.Int, 4);
         *  cmd.Parameters["@ProductId"].Value = p.ProductId;
         *  cmd.Parameters.Add("@ModelNumber", SqlDbType.VarChar, prodStringLen);
         *  cmd.Parameters["@ModelNumber"].Value = p.ModelNumber;
         *  cmd.Parameters.Add("@ModelName", SqlDbType.VarChar, prodStringLen);
         *  cmd.Parameters["@ModelName"].Value = p.ModelName;
         *  cmd.Parameters.Add("@UnitCost", SqlDbType.Decimal);
         *  cmd.Parameters["@UnitCost"].Value = p.UnitCost;
         *  cmd.Parameters.Add("@Description", SqlDbType.VarChar, 200);
         *  cmd.Parameters["@Description"].Value = p.Description;
         *  cmd.Parameters.Add("@CategoryName", SqlDbType.VarChar, prodStringLen);
         *  cmd.Parameters["@CategoryName"].Value = p.CategoryName;
         *  int rows = 0;
         *  try
         *  {
         *      con.Open();
         *      rows = cmd.ExecuteNonQuery();
         *  }
         *  catch (SqlException ex)
         *  {
         *      errorMessage = "Update SQL error, " + ex.Message;
         *      hasError = true;
         *  }
         *  catch (Exception ex)
         *  {
         *      errorMessage = "Update error, " + ex.Message;
         *      hasError = true;
         *  }
         *  finally
         *  {
         *      con.Close();
         *  }
         *  return (!hasError);
         * } //UpdateProduct()
         */
        public bool UpdateProduct(Product displayP)
        {
            try
            {
                SqlProduct      p  = new SqlProduct(displayP);
                LinqDataContext dc = new LinqDataContext();
                dc.UpdateProduct(p.ProductId, p.CategoryName, p.ModelNumber, p.ModelName, p.UnitCost, p.Description);
            }
            catch (Exception ex)
            {
                errorMessage = "Update error, " + ex.Message;
                hasError     = true;
            }
            return(!hasError);
        } //UpdateProduct()
예제 #20
0
 public bool DeleteInmueble(int inmuebleId)
 {
     hasError = false;
     try
     {
         LinqDataContext dc = new LinqDataContext();
         dc.DeleteInmueble(inmuebleId);
     }
     catch (Exception ex)
     {
         errorMessage = "Delete error, " + ex.Message;
         hasError     = true;
     }
     return(!hasError);
 }
예제 #21
0
        } //UpdateProduct()

/*
 *      public bool DeleteProduct(int productId)
 *      {
 *          hasError = false;
 *          SqlConnection con = new SqlConnection(conString);
 *          SqlCommand cmd = new SqlCommand("DeleteProduct", con);
 *          cmd.CommandType = CommandType.StoredProcedure;
 *          cmd.Parameters.Add("@ProductId", SqlDbType.Int, 4);
 *          cmd.Parameters["@ProductId"].Value = productId;
 *          try
 *          {
 *              con.Open();
 *              int rows = cmd.ExecuteNonQuery();
 *          }
 *          catch (SqlException ex)
 *          {
 *              errorMessage = "DELETE SQL error, " + ex.Message;
 *              hasError = true;
 *          }
 *          catch (Exception ex)
 *          {
 *              errorMessage = "DELETE error, " + ex.Message;
 *              hasError = true;
 *          }
 *          finally
 *          {
 *              con.Close();
 *          }
 *          return !hasError;
 *      }// DeleteProduct()
 */
        public bool DeleteProduct(int productId)
        {
            hasError = false;
            try
            {
                LinqDataContext dc = new LinqDataContext();
                dc.DeleteProduct(productId);
            }
            catch (Exception ex)
            {
                errorMessage = "Delete error, " + ex.Message;
                hasError     = true;
            }
            return(!hasError);
        }// DeleteProduct()
예제 #22
0
        private void btn_Save_Click(object sender, EventArgs e)
        {
            LinqDataContext linq = new LinqDataContext(Properties.Settings.Default.ConnectionString);

            Voucher.Tb_HrEmp emp = new Voucher.Tb_HrEmp();
            emp.EmpNo        = EmpNoTextEdit.Text;
            emp.FullNameArab = FullNameArabTextEdit.Text;
            emp.FullNameEng  = FullNameArabTextEdit.Text;
            emp.IqamaNo      = FullNameArabTextEdit.Text;
            emp.Is_deleted   = false;
            linq.Tb_HrEmps.InsertOnSubmit(emp);
            linq.SubmitChanges();
            MessageBox.Show("New Employee Added Successfully");
            Loadagain();
        }
예제 #23
0
        public static void Estehghaghi()
        {
            var bank = new LinqDataContext();

            var query = from p in bank.sarbazs
                        // where p.Id_Sarbaz==Id_sarbaz
                        select p;

            foreach (var items in query)
            {
                var x = items.مدت_كسر_خدمت_به_روز;
                var y = items.خدمت_قبلی_روز;
                var z = items.مدت_اضافه_خدمت_روز;
                if (x == "" || x == null)
                {
                    x = "0";
                }
                if (y == "" || y == null)
                {
                    y = "0";
                }
                if (z == "" || z == null)
                {
                    z = "0";
                }
                int Day_variable = -Convert.ToInt32(x)
                                   - Convert.ToInt32(y)
                                   + Convert.ToInt32(z);

                double Mounth_Variable = Convert.ToInt32(Day_variable / 30);

                var Khedmat_Mounth = 21 + Mounth_Variable;

                int E;
                if (items.تاهل == true)
                {
                    E = Convert.ToInt32(Khedmat_Mounth * 2.5);
                }
                else
                {
                    E = Convert.ToInt32(Khedmat_Mounth * 1);
                }

                items.استحقاقی = Convert.ToString(E);
            }
            bank.SubmitChanges();
            //  return E;
        }
예제 #24
0
        private void FrmEdit_M_Load(object sender, EventArgs e)
        {
            var LinqObj = new LinqDataContext();

            var query = (from tempTbl in LinqObj.Mashmoolins
                         where tempTbl.Id_Mashmoolin == int.Parse(txtID_M.Text)
                         select tempTbl).Single();

            this.txtID.Text         = query.شماره_ملی;
            this.txtName.Text       = query.نام;
            this.txtLastName.Text   = query.نام_خانوادگی;
            this.txtFatherName.Text = query.نام_پدر;
            this.txt_BirthYear.Text = query.تاریخ_تولد;

            var bank   = new LinqDataContext();
            var query1 = (from p in bank.Gradetbls
                          orderby p.Id_Grade
                          select new { p.Id_Grade, p.Grade }).Distinct();

            comboBox_Grade.DataSource    = query1;
            comboBox_Grade.DisplayMember = "Grade";
            comboBox_Grade.ValueMember   = "Id_Grade";
            comboBox_Grade.Text          = query.تحصیلات;

            txt_Address.Text = query.آدرس;
            txt_mobile.Text  = query.تلفن;
            txt_Explain.Text = query.توضیحات;



            txt_Reshteh.Text   = query.رشته;
            txt_Moaref.Text    = query.معرف;
            txt_Basij.Text     = query.سابقه_بسیج_فعال;
            txt_HozehJazb.Text = query.حوزه_جذب;
            txt_Ezaf.Text      = query.اضاف;

            chBox_Takmili.Checked   = Convert.ToBoolean(query.تکمیلی);
            chBox_ThirthDay.Checked = Convert.ToBoolean(query.سی_روزه);
            chBox_Moaf.Checked      = Convert.ToBoolean(query.معاف_از_رزم);
            chBox_Komiteh.Checked   = Convert.ToBoolean(query.کمیته_امداد);
            chBox_Behzisti.Checked  = Convert.ToBoolean(query.سازمان_بهزیستی);
            chBox_Taahol.Checked    = Convert.ToBoolean(query.تاهل);


            txt_EzamDate.Text = query.تاریخ_اعزام;
        }
예제 #25
0
        public string[] getMaterialIDList(string prefixText, int count)
        {
            LinqDataContext db      = new LinqDataContext();
            var             result1 = from u in db.TBMA_BZJINFOs
                                      where u.BZJ_HMCODE.StartsWith(prefixText)
                                      select u.BZJ_ID + " " + u.BZJ_NAME;
            var result2 = from v in db.TBMA_RAWMAINFOs
                          where v.RM_HMCODE.StartsWith(prefixText)
                          select v.RM_ID + " " + v.RM_NAME;
            var result3 = from w in db.TBMA_LVCGMAINFOs
                          where w.LVCG_HMCODE.StartsWith(prefixText)
                          select w.LVCG_ID + " " + w.LVCG_NAME;

            result1 = result1.Union <string>(result2);
            result1 = result1.Union <string>(result3);
            result1 = result1.Take <string>(count);
            string[] materialidlist = result1.ToArray <string>();
            return(materialidlist);
        }
예제 #26
0
 /*
 public bool AddProduct(Product displayP)
 {
     SqlProduct p = new SqlProduct(displayP);
     hasError = false;
     SqlConnection con = new SqlConnection(conString);
     SqlCommand cmd = new SqlCommand("AddProduct", con);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@ModelNumber", SqlDbType.VarChar, prodStringLen);
     cmd.Parameters["@ModelNumber"].Value = p.ModelNumber;
     cmd.Parameters.Add("@ModelName", SqlDbType.VarChar, prodStringLen);
     cmd.Parameters["@ModelName"].Value = p.ModelName;
     cmd.Parameters.Add("@UnitCost", SqlDbType.Decimal);
     cmd.Parameters["@UnitCost"].Value = p.UnitCost;
     cmd.Parameters.Add("@Description", SqlDbType.VarChar, 200);
     cmd.Parameters["@Description"].Value = p.Description;
     if (p.Description==null)  cmd.Parameters["@Description"].Value = DBNull.Value;
     cmd.Parameters.Add("@CategoryName", SqlDbType.VarChar, prodStringLen);
     cmd.Parameters["@CategoryName"].Value = p.CategoryName;
     cmd.Parameters.Add("@ProductId", SqlDbType.Int, 4);
     cmd.Parameters["@ProductId"].Value = p.ProductId;
     cmd.Parameters["@ProductId"].Direction = ParameterDirection.Output;
     try
     {
         con.Open();
         int rows = cmd.ExecuteNonQuery();                       //create the new product in DB
         p.ProductId = (int)cmd.Parameters["@ProductId"].Value;  //set the returned ProductId in the SqlProduct object
         displayP.ProductAdded2DB(p);                            //update corresponding Product ProductId using SqlProduct
     }
     catch (SqlException ex)
     {
         errorMessage = "Add SQL error, " + ex.Message;
         hasError = true;
     }
     catch (Exception ex)
     {
         errorMessage = "ADD error, " + ex.Message;
         hasError = true;
     }
     finally
     {
         con.Close();
     }
     return !hasError;
 } //AddProduct()
  */
 public bool AddProduct(Product displayP)
 {
     hasError = false;
     try
     {
         SqlProduct p = new SqlProduct(displayP);
         LinqDataContext dc = new LinqDataContext();
         int? newProductId = 0;
         dc.AddProduct(p.CategoryName, p.ModelNumber, p.ModelName, p.UnitCost, p.Description, ref newProductId);
         p.ProductId = (int)newProductId;
         displayP.ProductAdded2DB(p);    //update corresponding Product ProductId using SqlProduct
     }
     catch (Exception ex)
     {
         errorMessage = "Add error, " + ex.Message;
         hasError = true;
     }
     return !hasError;
 }
예제 #27
0
        public List <Employee> GetEmployees()
        {
            List <Employee> list = new List <Employee>();

            using (LinqDataContext linq = new LinqDataContext())
            {
                list = linq.SecuritySystemUsers
                       .Where(w => w.GCRecord == null && (w.Примечание != null || w.Компьютер != null))
                       .OrderBy(o => o.ФИО)
                       .Select(s => new Employee
                {
                    Name    = s.ФИО,
                    Phone   = s.Примечание,
                    Machine = s.Компьютер
                })
                       .ToList();
            }
            return(list);
        }
예제 #28
0
        }// DeleteProduct()

/*
 *      public bool AddProduct(Product displayP)
 *      {
 *          SqlProduct p = new SqlProduct(displayP);
 *          hasError = false;
 *          SqlConnection con = new SqlConnection(conString);
 *          SqlCommand cmd = new SqlCommand("AddProduct", con);
 *          cmd.CommandType = CommandType.StoredProcedure;
 *          cmd.Parameters.Add("@ModelNumber", SqlDbType.VarChar, prodStringLen);
 *          cmd.Parameters["@ModelNumber"].Value = p.ModelNumber;
 *          cmd.Parameters.Add("@ModelName", SqlDbType.VarChar, prodStringLen);
 *          cmd.Parameters["@ModelName"].Value = p.ModelName;
 *          cmd.Parameters.Add("@UnitCost", SqlDbType.Decimal);
 *          cmd.Parameters["@UnitCost"].Value = p.UnitCost;
 *          cmd.Parameters.Add("@Description", SqlDbType.VarChar, 200);
 *          cmd.Parameters["@Description"].Value = p.Description;
 *          if (p.Description==null)  cmd.Parameters["@Description"].Value = DBNull.Value;
 *          cmd.Parameters.Add("@CategoryName", SqlDbType.VarChar, prodStringLen);
 *          cmd.Parameters["@CategoryName"].Value = p.CategoryName;
 *          cmd.Parameters.Add("@ProductId", SqlDbType.Int, 4);
 *          cmd.Parameters["@ProductId"].Value = p.ProductId;
 *          cmd.Parameters["@ProductId"].Direction = ParameterDirection.Output;
 *          try
 *          {
 *              con.Open();
 *              int rows = cmd.ExecuteNonQuery();                       //create the new product in DB
 *              p.ProductId = (int)cmd.Parameters["@ProductId"].Value;  //set the returned ProductId in the SqlProduct object
 *              displayP.ProductAdded2DB(p);                            //update corresponding Product ProductId using SqlProduct
 *          }
 *          catch (SqlException ex)
 *          {
 *              errorMessage = "Add SQL error, " + ex.Message;
 *              hasError = true;
 *          }
 *          catch (Exception ex)
 *          {
 *              errorMessage = "ADD error, " + ex.Message;
 *              hasError = true;
 *          }
 *          finally
 *          {
 *              con.Close();
 *          }
 *          return !hasError;
 *      } //AddProduct()
 */
        public bool AddProduct(Product displayP)
        {
            hasError = false;
            try
            {
                SqlProduct      p            = new SqlProduct(displayP);
                LinqDataContext dc           = new LinqDataContext();
                int?            newProductId = 0;
                dc.AddProduct(p.CategoryName, p.ModelNumber, p.ModelName, p.UnitCost, p.Description, ref newProductId);
                p.ProductId = (int)newProductId;
                displayP.ProductAdded2DB(p);    //update corresponding Product ProductId using SqlProduct
            }
            catch (Exception ex)
            {
                errorMessage = "Add error, " + ex.Message;
                hasError     = true;
            }
            return(!hasError);
        } //AddProduct()
예제 #29
0
 public bool AddInmueble(Inmueble mostrarInmueble)
 {
     hasError = false;
     try
     {
         SqlInmueble     inmueble        = new SqlInmueble(mostrarInmueble);
         LinqDataContext dc              = new LinqDataContext();
         int?            nuevoInmuebleId = 0;
         dc.AddInmueble(inmueble.Categoria, inmueble.Direccion, inmueble.Vendedor, inmueble.Precio, inmueble.Descripcion, ref nuevoInmuebleId);
         inmueble.InmuebleId = (int)nuevoInmuebleId;
         mostrarInmueble.ProductAdded2DB(inmueble);
     }
     catch (Exception ex)
     {
         errorMessage = "Add error, " + ex.Message;
         hasError     = true;
     }
     return(!hasError);
 }
예제 #30
0
        private void btnApply_Click(object sender, EventArgs e)
        {
            var LinqObj = new LinqDataContext();

            var query = (from tempTbl in LinqObj.Mashmoolins
                         where tempTbl.Id_Mashmoolin == int.Parse(txtID_M.Text)
                         select tempTbl).Single();

            query.شماره_ملی    = this.txtID.Text;
            query.نام          = this.txtName.Text;
            query.نام_خانوادگی = this.txtLastName.Text;
            query.نام_پدر      = this.txtFatherName.Text;

            query.تاریخ_تولد = txt_BirthYear.Text;
            query.آدرس       = txt_Address.Text;
            query.تلفن       = txt_mobile.Text;
            query.تحصیلات    = comboBox_Grade.Text.ToString();
            query.کد_تحصیلات = Convert.ToInt32(comboBox_Grade.SelectedValue);
            query.رشته       = txt_Reshteh.Text;

            query.معرف            = txt_Moaref.Text;
            query.سابقه_بسیج_فعال = txt_Basij.Text;
            query.حوزه_جذب        = txt_HozehJazb.Text;
            query.اضاف            = txt_Ezaf.Text;

            query.تکمیلی         = chBox_Takmili.Checked;
            query.سی_روزه        = chBox_ThirthDay.Checked;
            query.معاف_از_رزم    = chBox_Moaf.Checked;
            query.کمیته_امداد    = chBox_Komiteh.Checked;
            query.سازمان_بهزیستی = chBox_Behzisti.Checked;
            query.تاهل           = chBox_Taahol.Checked;

            query.توضیحات     = txt_Explain.Text;
            query.تاریخ_اعزام = txt_EzamDate.Text;

            LinqObj.SubmitChanges();

            this.Close();
        }
예제 #31
0
        private void btnApply_Click(object sender, EventArgs e)
        {
            try
            {
                var LinqObj         = new LinqDataContext();
                var GradeReshtehObj = new Grade_Reshteh();

                var c = LinqObj.Grade_Reshtehs.Count();
                if (GVFeildCapacity.RowCount >= 1)
                {
                    for (int i = 1; i <= c; i++)
                    {
                        if (GVFeildCapacity.Rows[i].Cells[4].Value.ToString() == "")
                        {
                            GradeReshtehObj.Capacity = int.Parse(GVFeildCapacity.Rows[i].Cells[4].Value.ToString());
                        }

                        LinqObj.Grade_Reshtehs.InsertOnSubmit(GradeReshtehObj);
                    }
                    LinqObj.SubmitChanges();

                    /////////////////  referesh GVtable  /////////////
                    var bank  = new LinqDataContext();
                    var query = from temp in bank.Grade_Reshtehs
                                join tempjoin in bank.Reshtehas on temp.Id_CodeReshteh equals tempjoin.Id
                                join tempjoin2 in bank.Gradetbls on temp.Id_Grade equals tempjoin2.Id_Grade
                                select new { temp.Id_Grade_Reshteh, tempjoin2.Grade, tempjoin.Reshteh, tempjoin.CodeReshteh, temp.Capacity };

                    GVFeildCapacity.DataSource = query;

                    //////////////////////////////////////////////////
                }
            }
            catch (System.Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }
        }
예제 #32
0
 public void Dispose()
 {
     linqDc = null;
     errorLogDal = null;
 }
예제 #33
0
 public DatabaseAccessObject()
 {
     linqDc = new LinqDataContext();
 }
예제 #34
0
 /*
 private string GetStringOrNull(SqlDataReader reader, string columnName)
 {
     return reader.IsDBNull(reader.GetOrdinal(columnName)) ? "" : (string)reader[columnName];
 }
 */
 /*
 private const int prodStringLen = 50;
 public bool UpdateProduct(Product displayP)
 {
     SqlProduct p = new SqlProduct( displayP);
     hasError = false;
     SqlConnection con = new SqlConnection(conString);
     SqlCommand cmd = new SqlCommand("UpdateProduct", con);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@ProductId", SqlDbType.Int, 4);
     cmd.Parameters["@ProductId"].Value = p.ProductId;
     cmd.Parameters.Add("@ModelNumber", SqlDbType.VarChar, prodStringLen);
     cmd.Parameters["@ModelNumber"].Value = p.ModelNumber;
     cmd.Parameters.Add("@ModelName", SqlDbType.VarChar, prodStringLen);
     cmd.Parameters["@ModelName"].Value = p.ModelName;
     cmd.Parameters.Add("@UnitCost", SqlDbType.Decimal);
     cmd.Parameters["@UnitCost"].Value = p.UnitCost;
     cmd.Parameters.Add("@Description", SqlDbType.VarChar, 200);
     cmd.Parameters["@Description"].Value = p.Description;
     cmd.Parameters.Add("@CategoryName", SqlDbType.VarChar, prodStringLen);
     cmd.Parameters["@CategoryName"].Value = p.CategoryName;
     int rows = 0;
     try
     {
         con.Open();
         rows = cmd.ExecuteNonQuery();
     }
     catch (SqlException ex)
     {
         errorMessage = "Update SQL error, " + ex.Message;
         hasError = true;
     }
     catch (Exception ex)
     {
         errorMessage = "Update error, " + ex.Message;
         hasError = true;
     }
     finally
     {
         con.Close();
     }
     return (!hasError);
 } //UpdateProduct()
 */
 public bool UpdateProduct(Product displayP)
 {
     try
     {
         SqlProduct p = new SqlProduct(displayP);
         LinqDataContext dc = new LinqDataContext();
         dc.UpdateProduct(p.ProductId, p.CategoryName, p.ModelNumber, p.ModelName, p.UnitCost, p.Description);
     }
     catch (Exception ex)
     {
         errorMessage = "Update error, " + ex.Message;
         hasError = true;
     }
     return (!hasError);
 }
예제 #35
0
        /*
                private string conString = Properties.Settings.Default.StoreDBConnString;

                public MyObservableCollection<Product> GetProducts()
                {
                    hasError = false;
                    SqlConnection con = new SqlConnection(conString);
                    SqlCommand cmd = new SqlCommand("GetProducts", con);
                    cmd.CommandType = CommandType.StoredProcedure;

                    MyObservableCollection<Product> products = new MyObservableCollection<Product>();
                    try
                    {
                        con.Open();
                        SqlDataReader reader = cmd.ExecuteReader();
                        while (reader.Read())
                        {
                            //create a Product object for the row
                            SqlProduct sqlProduct = new SqlProduct(
                                (int) reader["ProductId"],
                                (string)reader["ModelNumber"],
                                (string)reader["ModelName"],
                                (decimal)reader["UnitCost"],
                                GetStringOrNull(reader, "Description"),
                                (String)reader["CategoryName"]);
                            products.Add(sqlProduct.SqlProduct2Product());
                        } //while
                    } //try
                    catch (SqlException ex)
                    {
                        errorMessage = "GetProducts SQL error, " + ex.Message;
                        hasError = true;
                    }
                    catch (Exception ex)
                    {
                        errorMessage = "GetProducts error, " + ex.Message;
                        hasError = true;
                    }
                    finally
                    {
                        con.Close();
                    }
                    return products;
                } //GetProducts()
        */
        public MyObservableCollection<Product> GetProducts()
        {
            hasError = false;
            MyObservableCollection<Product> products = new MyObservableCollection<Product>();
            try
            {
                LinqDataContext dc = new LinqDataContext();
                var query = from q in dc.LinqProducts
                    select new SqlProduct{
                        ProductId = q.ProductID, ModelNumber = q.ModelNumber,
                        ModelName=q.ModelName, UnitCost = (decimal)q.UnitCost,
                        Description = q.Description, CategoryName = q.LinqCategory.CategoryName
                    };
                foreach (SqlProduct sp in query)
                    products.Add(sp.SqlProduct2Product());
            } //try
            catch(Exception ex)
            {
                errorMessage = "GetProducts() error, " + ex.Message;
                hasError = true;
            }
            return products;
        }
예제 #36
0
 /*
 public bool DeleteProduct(int productId)
 {
     hasError = false;
     SqlConnection con = new SqlConnection(conString);
     SqlCommand cmd = new SqlCommand("DeleteProduct", con);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@ProductId", SqlDbType.Int, 4);
     cmd.Parameters["@ProductId"].Value = productId;
     try
     {
         con.Open();
         int rows = cmd.ExecuteNonQuery();
     }
     catch (SqlException ex)
     {
         errorMessage = "DELETE SQL error, " + ex.Message;
         hasError = true;
     }
     catch (Exception ex)
     {
         errorMessage = "DELETE error, " + ex.Message;
         hasError = true;
     }
     finally
     {
         con.Close();
     }
     return !hasError;
 }// DeleteProduct()
 */
 public bool DeleteProduct(int productId)
 {
     hasError = false;
     try
     {
         LinqDataContext dc = new LinqDataContext();
         dc.DeleteProduct(productId);
     }
     catch (Exception ex)
     {
         errorMessage = "Delete error, " + ex.Message;
         hasError = true;
     }
     return !hasError;
 }