示例#1
0
        public static DataTable ParseToDataTable(IList<Data.PemeriksaanDetail> srs)
        {
            DataTable deta = new DataTable();

            foreach (PropertyInfo info in typeof(Data.PemeriksaanDetail).GetProperties())
            {
                deta.Columns.Add(info.Name, info.PropertyType);
            }
            deta.AcceptChanges();

            foreach (var i in srs)
            {
                Data.PemeriksaanDetail sr = new Data.PemeriksaanDetail();
                sr = i;
                DataRow row = deta.NewRow();

                foreach (var property in sr.GetType().GetProperties())
                {
                    row[property.Name] = property.GetValue(sr, null);
                }
                deta.Rows.Add(row);
            }

            deta.AcceptChanges();
            return deta;
        }
示例#2
0
        public static string SP_FindPemeriksaanById(string id, out Data.Pemeriksaan p)
        {
            p = null;
            SqlConnection sqlConn = new SqlConnection();
            SqlCommand sqlCmd = new SqlCommand();
            SqlDataAdapter sqlAdap = new SqlDataAdapter();

            try
            {
                sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["AMS_StockConnectionString"].ToString();
                sqlConn.Open();

                sqlCmd.CommandText = "SP_FindPemeriksaanById";
                sqlCmd.CommandType = CommandType.StoredProcedure;
                sqlCmd.Connection = sqlConn;

                SqlParameter parm1 = new SqlParameter("@Id", SqlDbType.Int);
                parm1.Value = int.Parse(id);
                parm1.Direction = ParameterDirection.Input;
                sqlCmd.Parameters.Add(parm1);

                sqlAdap.SelectCommand = sqlCmd;
                DataSet ds = new DataSet();
                sqlAdap.Fill(ds);

                DataRow dr = ds.Tables[0].Rows[0];
                p = new Data.Pemeriksaan
                {
                    Id = (int)dr["Id"],
                    LembagaId = dr["LembagaId"].ToString()
                };

                for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
                {
                    Data.PemeriksaanDetail pd = new Data.PemeriksaanDetail
                    {
                        Id = int.Parse(ds.Tables[1].Rows[i]["Id"].ToString()),
                        StockRegId = int.Parse(ds.Tables[1].Rows[i]["StockRegId"].ToString()),
                        CurrentBalance = int.Parse(ds.Tables[1].Rows[i]["Balance"].ToString()),
                        ParasMenokok = int.Parse(ds.Tables[1].Rows[i]["ParasMenokok"].ToString()),
                        StockId = int.Parse(ds.Tables[1].Rows[i]["StockId"].ToString()),
                        StockCode = ds.Tables[1].Rows[i]["StockRegNo"].ToString(),
                        StockName = ds.Tables[1].Rows[i]["StockDetail"].ToString()

                    };
                    p.Details.Add(pd);
                }
                //DataRow drDetail = ds.Tables[0].Rows[0];

                return string.Empty;
            }
            catch (Exception err)
            {
                return err.Message;
            }
            finally
            { sqlConn.Close(); sqlConn.Dispose(); sqlCmd.Dispose(); }
        }
        private void Save(string CurrUser)
        {
            try
            {
                var glLembagaName = FindControlRecursive(this, "glLembagaName") as ASPxGridLookup;
                var gvSenaraiStok = FindControlRecursive(this, "gvSenaraiStok") as ASPxGridView;

                Data.Pemeriksaan p = new Data.Pemeriksaan
                {
                    LembagaId = glLembagaName.Value.ToString(),
                };

                for (int i = 0; i < gvSenaraiStok.VisibleRowCount; i++)
                {
                    Data.PemeriksaanDetail sr = new Data.PemeriksaanDetail();
                    sr.StockRegId = int.Parse(gvSenaraiStok.GetRowValues(i, "Id").ToString());
                    p.Details.Add(sr);
                }

                string err = Core.Stor.PemeriksaanMethods.SP_PemeriksaanSave(int.Parse(CurrUser), p);

                if (err == "")
                {
                    cbp_Main.JSProperties["cpErrMsg"] = string.Empty;
                }
                else
                {
                    string errMsg = ConfigurationManager.AppSettings["ErrorMessageStaringSentenceDBError"].ToString();
                    errMsg = errMsg.Replace("BR", "<br><br>");
                    cbp_Main.JSProperties["cpErrMsg"] = errMsg + " " + err;
                }
            }
            catch (Exception err)
            {
                string errMsg = ConfigurationManager.AppSettings["ErrorMessageStaringSentenceCaughtByExceptions"].ToString();
                errMsg = errMsg.Replace("BR", "<br><br>");
                cbp_Main.JSProperties["cpErrMsg"] = errMsg + " " + err;
            }
            finally
            { }
        }
        private void LoadStock(Data.Pemeriksaan p)
        {
            List<Data.PemeriksaanDetail> srs = new List<Data.PemeriksaanDetail>();
            try
            {

                for (int x = 0; x < p.Details.Count; x++)
                {
                    Data.PemeriksaanDetail sr = new Data.PemeriksaanDetail();

                    sr.Id = p.Details[x].StockRegId;
                    sr.StockId = p.Details[x].StockId;
                    sr.StockCode = p.Details[x].StockCode;
                    sr.StockName = p.Details[x].StockName;
                    sr.CurrentBalance = p.Details[x].CurrentBalance;
                    sr.ParasMenokok = p.Details[x].ParasMenokok;
                    srs.Add(sr);
                }

                Tab_Pemeriksaan_Controller1.BindSenaraiStok(srs);

                cbp_Main.JSProperties["cpErrMsg"] = string.Empty;
            }
            catch (Exception err)
            {
                string errMsg = ConfigurationManager.AppSettings["ErrorMessageStaringSentenceCaughtByExceptions"].ToString();
                errMsg = errMsg.Replace("BR", "<br><br>");
                cbp_Main.JSProperties["cpErrMsg"] = errMsg + " " + err.Message;
            }
            finally
            { }
        }
        private void AddStock()
        {
            List<Data.PemeriksaanDetail> srs = new List<Data.PemeriksaanDetail>();
            try
            {
                var gvSearchStockReg = FindControlRecursive(this, "gvSearchStockReg") as ASPxGridView;

                if (gvSearchStockReg.Selection.Count == 0)
                {
                    cbp_Main.JSProperties["cpErrMsg"] = string.Empty;
                    return;
                }

                for (int x = 0; x < gvSearchStockReg.VisibleRowCount; x++)
                {
                    if (gvSearchStockReg.Selection.IsRowSelected(x))
                    {
                        Data.PemeriksaanDetail sr = new Data.PemeriksaanDetail();

                        sr.Id = int.Parse(gvSearchStockReg.GetRowValues(x, "StockRegId").ToString());
                        sr.StockId = int.Parse(gvSearchStockReg.GetRowValues(x, "StockId").ToString());
                        sr.StockCode = gvSearchStockReg.GetRowValues(x, "StockRegNo").ToString();
                        sr.StockName = gvSearchStockReg.GetRowValues(x, "StockDetail").ToString();
                        sr.CurrentBalance = int.Parse(gvSearchStockReg.GetRowValues(x, "Balance").ToString());
                        sr.ParasMenokok = int.Parse(gvSearchStockReg.GetRowValues(x, "ParasMenokok").ToString());

                        srs.Add(sr);
                    }
                }

                Tab_Pemeriksaan_Controller1.BindSenaraiStok(srs);

                cbp_Main.JSProperties["cpErrMsg"] = string.Empty;
            }
            catch (Exception err)
            {
                string errMsg = ConfigurationManager.AppSettings["ErrorMessageStaringSentenceCaughtByExceptions"].ToString();
                errMsg = errMsg.Replace("BR", "<br><br>");
                cbp_Main.JSProperties["cpErrMsg"] = errMsg + " " + err.Message;
            }
            finally
            { }
        }