Esempio n. 1
0
        public TransactionStatus CreatePincode(PincodeBo pincodeBo)
        {
            var transactionStatus = new TransactionStatus();

            var con = new CemexDb();

            //var pinCode = BuiltPincodeDomain(pincodeBo);

            //CemexDb.Pincode.Add(pinCode);
            //CemexDb.SaveChanges();

            SqlParameter[] Params =
            {
                new SqlParameter("@Pincode", SqlDbType.NVarChar), //0
                new SqlParameter("@opReturnValue", SqlDbType.Int) //1
            };

            if (!String.IsNullOrEmpty(pincodeBo.Pincode))
            {
                Params[0].Value = pincodeBo.Pincode;
            }
            else
            {
                Params[0].Value = DBNull.Value;
            }

            Params[1].Direction = ParameterDirection.Output;
            //string conStr = ConfigurationManager.ConnectionStrings["conCityOfLongBeach"].ToString();
            DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddPincode", Params);

            ds.Locale = CultureInfo.InvariantCulture;
            //return Params[5].Value.ToString();

            return(transactionStatus);
        }
Esempio n. 2
0
 private Lmk_Pincode BuiltPincodeDomain(PincodeBo pincodeBo)
 {
     return((Lmk_Pincode) new Lmk_Pincode().InjectFrom(pincodeBo));
 }