Esempio n. 1
0
        public string InsertStock(StockHeader header, string User)
        {
            string err = "";

            try
            {
                conn.BeginTransaction();
                DataSet             ds       = new DataSet();
                Int32               HeaderID = 0;
                bool                chk      = false;
                List <SqlParameter> param    = new List <SqlParameter>();
                param.Add(new SqlParameter()
                {
                    ParameterName = "StockType", Value = header.StockType
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "StockTime", Value = header.StockTime
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "Remark", Value = header.Remark
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CreatedBy", Value = User
                });
                conn.CallStoredProcedure("InsStockHeader", param, out ds, out err);
                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && string.IsNullOrEmpty(err) && header.detail != null && header.detail.Count > 0)
                {
                    HeaderID = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                    string cal = header.StockType == "IN" ? "+" : "-";
                    foreach (StockDetail item in header.detail)
                    {
                        param = new List <SqlParameter>();
                        param.Add(new SqlParameter()
                        {
                            ParameterName = "StockHeaderID", Value = HeaderID
                        });
                        param.Add(new SqlParameter()
                        {
                            ParameterName = "ProductID", Value = item.ProductID, DbType = DbType.Int32
                        });
                        param.Add(new SqlParameter()
                        {
                            ParameterName = "Amount", Value = item.Amount, DbType = DbType.Int32
                        });
                        param.Add(new SqlParameter()
                        {
                            ParameterName = "CAL", Value = cal
                        });
                        param.Add(new SqlParameter()
                        {
                            ParameterName = "SerialNumber", Value = item.SNConcat
                        });
                        conn.CallStoredProcedure("InsStockDetail", param, out err);

                        if (item.lstSerial != null && item.lstSerial.Count > 0)
                        {
                            foreach (TransProductSerial tps in item.lstSerial)
                            {
                                ds    = new DataSet();
                                param = new List <SqlParameter>();
                                param.Add(new SqlParameter()
                                {
                                    ParameterName = "ProductID", Value = item.ProductID, DbType = DbType.Int32
                                });
                                param.Add(new SqlParameter()
                                {
                                    ParameterName = "SerialNumber", Value = tps.SerialNumber
                                });
                                param.Add(new SqlParameter()
                                {
                                    ParameterName = "CAL", Value = cal
                                });
                                conn.CallStoredProcedure("InsTransProductSerial", param, out ds, out err);
                                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
                                {
                                    err = err + tps.SerialNumber + ", ";
                                    chk = true;
                                }
                            }

                            if (chk)
                            {
                                err = "ไม่พบ S/N หมายเลข : " + err.Substring(0, err.Length - 2);
                            }
                        }
                    }
                }

                if (string.IsNullOrEmpty(err))
                {
                    conn.Commit();
                }
                else
                {
                    conn.RollBack();
                }
            }
            catch (Exception ex)
            {
                err = ex.Message;
            }
            return(err);
        }
Esempio n. 2
0
        public string InsertSaleHeader(TransSaleHeader o, List <SaleDetailDTO> lstDetail)
        {
            string error = "";

            try
            {
                DataSet             ds = new DataSet();
                List <SqlParameter> param = new List <SqlParameter>();
                Int32 HeaderID = 0, DetailID = 0;

                conn.BeginTransaction();
                #region Header Params
                param.Add(new SqlParameter()
                {
                    ParameterName = "tel", Value = o.Tel, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CustomerName", Value = o.CustomerName, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CustomerAddress", Value = o.CustomerAddress, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CustomerDistrict", Value = o.CustomerDistrict, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CustomerCountry", Value = o.CustomerCountry, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CustomerProvince", Value = o.CustomerProvince, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CustomerPostalCode", Value = o.CustomerPostalCode, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "DeliverName", Value = o.DeliveryName, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "DeliverAddress", Value = o.DeliverAdd, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "DeliverDistrict", Value = o.DeliverDistrict, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "DeliverCountry", Value = o.DeliverCountry, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "DeliverProvince", Value = o.DeliverProvince, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "DeliverPostalCode", Value = o.DeliverPostalCode, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "ReceivedDate", Value = o.ReceivedDate, DbType = DbType.DateTime
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "ReceivedBy", Value = o.ReceivedBy, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "SaleNumber", Value = o.SaleNumber, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "Remark", Value = o.Remark, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "ConsignmentNo", Value = o.ConsignmentNo, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "COD", Value = o.COD, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "WarrantyDate", Value = o.WarrantyDate, DbType = DbType.DateTime
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "BillType", Value = o.BillType, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "PayType", Value = o.PayType, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "SaleName", Value = o.SaleName, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "AccountTransfer", Value = o.AccountTransfer, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "TimeTransfer", Value = o.TimeTransfer, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "Installment", Value = o.Installment, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "Active", Value = o.Active, DbType = DbType.String
                });
                param.Add(new SqlParameter()
                {
                    ParameterName = "CreatedBy", Value = o.CreatedBy, DbType = DbType.String
                });
                #endregion

                conn.CallStoredProcedure("InsTransSaleHeader", param, out ds, out error);
                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0 && string.IsNullOrEmpty(error))
                {
                    HeaderID = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                    if (lstDetail != null && lstDetail.Count > 0)
                    {
                        Int32    TransID = 0;
                        string   tid     = "";
                        string[] tidArr;
                        foreach (SaleDetailDTO item in lstDetail)
                        {
                            param = new List <SqlParameter>();
                            param.Add(new SqlParameter()
                            {
                                ParameterName = "HeaderID", Value = HeaderID, DbType = DbType.Int32
                            });
                            param.Add(new SqlParameter()
                            {
                                ParameterName = "ItemID", Value = item.ItemID, DbType = DbType.Int32
                            });
                            param.Add(new SqlParameter()
                            {
                                ParameterName = "ItemPrice", Value = item.ItemPrice, DbType = DbType.Decimal
                            });
                            param.Add(new SqlParameter()
                            {
                                ParameterName = "Amount", Value = item.Amount, DbType = DbType.Decimal
                            });
                            param.Add(new SqlParameter()
                            {
                                ParameterName = "Discount", Value = item.Discount, DbType = DbType.Decimal
                            });
                            param.Add(new SqlParameter()
                            {
                                ParameterName = "SerialNumber", Value = item.SerialNumber, DbType = DbType.String
                            });
                            param.Add(new SqlParameter()
                            {
                                ParameterName = "ItemDetail", Value = item.ItemDescription, DbType = DbType.String
                            });
                            conn.CallStoredProcedure("InsTransSaleDetail", param, out ds, out error);

                            #region Status = 'N' on SerialNumber
                            tid = item.SNID;
                            if (!string.IsNullOrEmpty(tid) && string.IsNullOrEmpty(error))
                            {
                                tidArr = tid.Split(',');
                                if (tidArr != null && tidArr.Length > 0)
                                {
                                    foreach (string s in tidArr)
                                    {
                                        TransID = Convert.ToInt32(s);
                                        param   = new List <SqlParameter>();
                                        param.Add(new SqlParameter()
                                        {
                                            ParameterName = "TransID", Value = TransID, DbType = DbType.Int32
                                        });
                                        conn.CallStoredProcedure("UpdTransProductSerialStatus", param, out error);
                                    }
                                }
                            }
                            #endregion

                            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0 && item.ProductDetail != null && item.ProductDetail.Count > 0 && string.IsNullOrEmpty(error))
                            {
                                DetailID = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                                foreach (MasPackageDetail pd in item.ProductDetail)
                                {
                                    param = new List <SqlParameter>();
                                    param.Add(new SqlParameter()
                                    {
                                        ParameterName = "SaleDetailID", Value = DetailID, DbType = DbType.Int32
                                    });
                                    param.Add(new SqlParameter()
                                    {
                                        ParameterName = "ProductID", Value = pd.ProductID, DbType = DbType.Int32
                                    });
                                    param.Add(new SqlParameter()
                                    {
                                        ParameterName = "Amount", Value = pd.Amount, DbType = DbType.Int32
                                    });
                                    param.Add(new SqlParameter()
                                    {
                                        ParameterName = "IsFree", Value = pd.IsFree
                                    });
                                    conn.CallStoredProcedure("InsTransSaleDetailProduct", param, out error);
                                }
                            }
                        }
                    }
                }

                if (string.IsNullOrEmpty(error))
                {
                    conn.Commit();
                }
                else
                {
                    conn.RollBack();
                }
            }
            catch (Exception ex)
            {
                error = ex.Message;
            }
            return(error);
        }