コード例 #1
0
        public TransactionStatus EditLocation(EditLocationBo editlocationBo)
        {
            var transactionStatus = new TransactionStatus();
            var editlocation      = BuiltEditPincodeDomain(editlocationBo);

            var           con  = new CemexDb();
            SqlConnection conn = con.GetConnection();

            conn.Open();
            SqlCommand cmd = new SqlCommand("dbo.proc_UpdateLocation", conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Location_Id", Convert.ToInt32(editlocation.Location_Id));
            cmd.Parameters.AddWithValue("@Location_desc", editlocation.Location_desc);
            cmd.Parameters.AddWithValue("@opReturnValue", 1);
            cmd.ExecuteNonQuery();

            return(transactionStatus);
        }
コード例 #2
0
 private EditLocationBo BuiltEditPincodeDomain(EditLocationBo editpincodeBo)
 {
     return((EditLocationBo) new EditLocationBo().InjectFrom(editpincodeBo));
 }