public JsonResult warehouse_in_up(warehouse_in_up_lib objHeader) { objHeader.company_id = Convert.ToInt32(Crypto.url_decrypt(Request.Cookies["CompanyId"])); objHeader.created_by = Convert.ToInt32(Crypto.url_decrypt(Request.Cookies["UserId"])); warehouse_in_up_lib result = _master.warehouse_in_upAsync(objHeader).Result; JsonResult json = Json(result); return(json); }
public warehouse_in_up_lib warehouse_in_up(warehouse_in_up_lib obj) { warehouse_in_up_lib ret = new warehouse_in_up_lib(); SqlConnection oConn = new SqlConnection(_master); SqlTransaction oTrans; oConn.Open(); oTrans = oConn.BeginTransaction(); SqlCommand oCmd = new SqlCommand(); oCmd.Connection = oConn; oCmd.Transaction = oTrans; try { var path = "\\Uploaded\\Images\\" + obj.company_id + "\\warehouse\\" + obj.image_path; oCmd.CommandText = "warehouse_in_up"; oCmd.CommandType = CommandType.StoredProcedure; oCmd.Parameters.Clear(); oCmd.Parameters.AddWithValue("@warehouse_id", obj.warehouse_id); oCmd.Parameters.AddWithValue("@image_path", path); oCmd.Parameters.AddWithValue("@name", obj.name); oCmd.Parameters.AddWithValue("@description", obj.description); oCmd.Parameters.AddWithValue("@tin", obj.tin); oCmd.Parameters.AddWithValue("@phone", obj.phone); oCmd.Parameters.AddWithValue("@fax", obj.fax); oCmd.Parameters.AddWithValue("@email", obj.email); oCmd.Parameters.AddWithValue("@address", obj.address); oCmd.Parameters.AddWithValue("@created_by", obj.created_by); oCmd.Parameters.AddWithValue("@company_id", obj.company_id); oCmd.Parameters.AddWithValue("@active", obj.active); SqlDataReader sdr = oCmd.ExecuteReader(); while (sdr.Read()) { ret.warehouse_id = Convert.ToInt32(sdr["warehouse_id"].ToString()); } sdr.Close(); oTrans.Commit(); } catch (Exception e) { Console.WriteLine("Error: " + e.Message); error_log_in("0", "SP = login_users_view_sel | " + e.Message, Convert.ToInt32(ret.company_id), 0); } finally { oConn.Close(); } return(ret); }