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); }
private Lmk_Pincode BuiltPincodeDomain(PincodeBo pincodeBo) { return((Lmk_Pincode) new Lmk_Pincode().InjectFrom(pincodeBo)); }