Exemplo n.º 1
0
            /// <summary>
            /// Insert Product Type Information
            /// </summary>
            /// <param name="data">Product Type Information</param>
            /// <returns>Number Affected Row</returns>
            public static Tuple <ErrorObject, string> ProductType(tblProductType data)
            {
                erros = new ErrorObject();
                try
                {
                    using (HSCMEntities db = new HSCMEntities())
                    {
                        int propertyFind = db.tblProductType.Count();
                        if (propertyFind > 0)
                        {
                            data.id = db.tblCellarArea.Max(s => s.id);
                        }
                        else
                        {
                            data.id = 1;
                        }
                        db.tblProductType.Add(data);
                        result  = db.SaveChanges();
                        Message = "Affected Row: " + result.ToString();

                        return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
                    }
                }
                catch (Exception ex)
                {
                    erros.InfoError(ex);
                    return(new Tuple <ErrorObject, string>(erros, String.Empty));
                }
            }
Exemplo n.º 2
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        ProductTypeModel model = new ProductTypeModel();
        tblProductType   pt    = CreateProductType();

        lblResult.Text = model.InsertProduct(pt);
    }
            /// <summary>
            /// Return Affected Row Or Error If Exist
            /// </summary>
            /// <param name="request">ProductType Information</param>
            /// <returns>Affected Row Or Error If Exist</returns>
            public static GetProductTypeResponse ProductType(GetProductTypeResponse request)
            {
                GetProductTypeResponse response = new GetProductTypeResponse();

                try
                {
                    tblProductType ProductType = new tblProductType()
                    {
                        id         = request.ProductType.id,
                        name       = request.ProductType.name,
                        detail     = request.ProductType.detail,
                        createDate = request.ProductType.createDate,
                        upDateDate = DateTime.Now,
                        deleteDate = null,
                        state      = "Active"
                    };

                    var result = ProductTypeData.Update.ProductType(ProductType);
                    if (result.Item1.Error)
                    {
                        response.Error.InfoError(result.Item1);
                    }
                    else
                    {
                        response.Message = result.Item2;
                    }
                }
                catch (Exception ex)
                {
                    response.Error.InfoError(ex);
                }

                return(response);
            }
Exemplo n.º 4
0
    private tblProductType CreateProductType()
    {
        tblProductType p = new tblProductType();

        p.Name = txtName.Text;

        return(p);
    }
Exemplo n.º 5
0
    public string InsertProduct(tblProductType productType)
    {
        try
        {
            OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
            db.tblProductTypes.Add(productType);
            db.SaveChanges();

            return(productType.Name + " was successfully inserted");
        }
        catch (Exception e)
        {
            return("Error: " + e);
        }
    }
Exemplo n.º 6
0
    public string DeleteProduct(int id)
    {
        try
        {
            OnlineKitchenDBEntities db          = new OnlineKitchenDBEntities();
            tblProductType          productType = db.tblProductTypes.Find(id);

            db.tblProductTypes.Attach(productType);
            db.tblProductTypes.Remove(productType);
            db.SaveChanges();

            return(productType.Name + " was successfully deleted");
        }
        catch (Exception e)
        {
            return("Error: " + e);
        }
    }
Exemplo n.º 7
0
            /// <summary>
            /// Update Cellar Area Information
            /// </summary>
            /// <param name="data">Cellar Area Information</param>
            /// <returns>Number Affected Row</returns>
            public static Tuple <ErrorObject, string> ProductType(tblProductType data)
            {
                erros = new ErrorObject();
                try
                {
                    using (HSCMEntities db = new HSCMEntities())
                    {
                        db.Entry(data).State = EntityState.Modified;
                        result  = db.SaveChanges();
                        Message = "Affected Row: " + result.ToString();

                        return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
                    }
                }
                catch (Exception ex)
                {
                    erros.InfoError(ex);
                    return(new Tuple <ErrorObject, string>(erros, String.Empty));
                }
            }
Exemplo n.º 8
0
    public string UpdateProduct(int id, tblProductType productType)
    {
        try
        {
            OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();

            //Fetch object from db
            tblProductType p = db.tblProductTypes.Find(id);

            p.Name = productType.Name;


            db.SaveChanges();
            return(productType.Name + " was successfully updated");
        }
        catch (Exception e)
        {
            return("Error: " + e);
        }
    }
Exemplo n.º 9
0
            /// <summary>
            /// Return Product Type By Specific ID
            /// </summary>
            /// <param name="id">Product Type ID</param>
            /// <returns>Produc Type By Specific ID Or null If Exist Error</returns>
            public static Tuple <ErrorObject, tblProductType> GetProductType(int id)
            {
                tblProductType productType = new tblProductType();

                erros = new ErrorObject();

                try
                {
                    using (HSCMEntities db = new HSCMEntities())
                    {
                        productType = db.tblProductType.Find(id);
                    }
                    erros.Error = false;
                    return(new Tuple <ErrorObject, tblProductType>(erros.IfError(false), productType));
                }
                catch (Exception ex)
                {
                    erros.InfoError(ex);
                    return(new Tuple <ErrorObject, tblProductType>(erros, productType));
                }
            }
Exemplo n.º 10
0
            /// <summary>
            /// Update Cellar Area Information
            /// </summary>
            /// <param name="data">Cellar Area Information</param>
            /// <returns>Number Affected Row</returns>
            public static Tuple <ErrorObject, string> ProductType(tblProductType data)
            {
                erros = new ErrorObject();
                try
                {
                    using (EileenGaldamezEntities db = new EileenGaldamezEntities())
                    {
                        var row = db.tblProductType.Single(p => p.id == data.id);
                        row.name       = data.name;
                        row.detail     = data.detail;
                        row.upDateDate = data.upDateDate;
                        result         = db.SaveChanges();
                        Message        = "Affected Row: " + result.ToString();

                        return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
                    }
                }
                catch (Exception ex)
                {
                    erros.InfoError(ex);
                    return(new Tuple <ErrorObject, string>(erros, String.Empty));
                }
            }