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);
}
