public IEnumerable <sp_car_search_v3_Result> search(carModel value)
{
StandardCanEntities context = new StandardCanEntities();
IEnumerable <sp_car_search_v3_Result> result = context.sp_car_search_v3(value.car_type_from, value.car_type_to, value.car_from, value.car_to).AsEnumerable();
return(result);
}
public messageModel delete(carModel value)
{
messageModel result = new messageModel();
try
{
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
int ret = context.sp_car_delete(value.id, userId);
}
result.status = "S";
result.message = "";
}
catch (Exception ex)
{
result.status = "E";
result.message = ex.Message.ToString();
}
return(result);
}
public carMasterModel master(carModel value)
{
carMasterModel result = new carMasterModel();
try
{
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
string sql = "select convert(nvarchar(5), MCT_ID) code ";
sql += " , MCT_NAME [text] ";
sql += " from MAS_CAR_TYPE ";
sql += " where MCT_STATUS = 1 ";
sql += " order by MCT_NAME ";
result.car_type = context.Database.SqlQuery <dropdown>(sql).ToList();
sql = "select convert(nvarchar(5), MCA_ID) code ";
sql += " , MCA_NAME [text] ";
sql += " from MAS_CAR ";
sql += " where MCT_ID = " + (value.carTypes ?? "0") + "AND MCA_STATUS = 1 ";
sql += " order by MCA_NAME ";
result.car_license = context.Database.SqlQuery <dropdown>(sql).ToList();
sql = "select convert(nvarchar(5), MCR_ID) code ";
sql += " , MCR_NAME[text] ";
sql += " from MAS_CAR_REASON ";
sql += " where MCR_STATUS = 1 ";
sql += " order by MCR_NAME ";
result.car_reason = context.Database.SqlQuery <dropdown>(sql).ToList();
sql = " select convert(nvarchar(5), MAS_ID) code, mas_name [text] ";
sql += " from MAS_APPROVE_STATUS ";
sql += " where MAS_ID != 0 ";
sql += " order by mas_orderby ";
result.car_status = context.Database.SqlQuery <dropdown>(sql).ToList();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(result);
}
protected void addBtn_Click(object sender, EventArgs e)
{
CarRepository carRepository = new CarRepository();
carModel data = new carModel()
{
carId = idTxt.Text,
carName = nameTxt.Text
};
carRepository.AddCarType(data);
Response.Redirect("Inventory.aspx");
}
public void AddCarType(carModel data)
{
SqlConnection conn = new SqlConnection(conStr);
string query = "insert into CarTypeLV1 values (@Id, @Name)";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
cmd.Parameters.AddWithValue("@Id", data.carId);
cmd.Parameters.AddWithValue("@Name", data.carName);
cmd.ExecuteScalar();
conn.Close();
conn.Dispose();
}
// POST api/<controller>
public HttpResponseMessage Post([FromBody] carModel value)
{
if (value == null)
{
return(null);
}
JavaScriptSerializer js = new JavaScriptSerializer();
carService service = new carService();
HttpResponseMessage response = null;
Object result = null;
switch (value.method)
{
case "master":
result = service.master(value);
break;
case "search":
result = service.search(value);
break;
case "insert":
result = service.insert(value);
break;
case "update":
result = service.update(value);
break;
case "delete":
result = service.delete(value);
break;
default:
break;
}
string json = js.Serialize(result);
response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json");
return(response);
}
public messageModel insert(carModel value)
{
messageModel result = new messageModel();
try
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
System.Data.Entity.Core.Objects.ObjectParameter myOutputParamInt = new System.Data.Entity.Core.Objects.ObjectParameter("r_id", typeof(Int32));
using (var context = new StandardCanEntities())
{
//int ret = context.sp_car_insert(value.car_type, value.name, value.detail, userId, myOutputParamInt);
}
if (myOutputParamInt.Value != null)
{
int r_id = Convert.ToInt32(myOutputParamInt.Value);
result.status = "S";
result.message = "";
result.value = r_id.ToString();
}
else
{
result.status = "E";
result.message = "";
}
}
catch (Exception ex)
{
result.status = "E";
result.message = ex.Message.ToString();
}
return(result);
}
public IEnumerable <sp_car_search_v2_Result> search(carModel value)
{
try
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
StandardCanEntities context = new StandardCanEntities();
IEnumerable <sp_car_search_v2_Result> result = context.sp_car_search_v2(value.car_type_from, value.car_type_to, value.car_from, value.car_to).AsEnumerable();
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtType.Text) && !string.IsNullOrWhiteSpace(txtMark.Text) &&
!string.IsNullOrWhiteSpace(txtModel.Text) && !string.IsNullOrWhiteSpace(txtPlate.Text) &&
!string.IsNullOrWhiteSpace(txtColor.Text) && !string.IsNullOrWhiteSpace(txtRate.Text) &&
!string.IsNullOrWhiteSpace(txtYear.Text) && numCap.Value != 0)
{
if (db.carTypes.FirstOrDefault(t => t.Name.ToLower() == txtType.Text.ToLower()) == null)
{
carType type = new carType();
type.Name = txtType.Text;
db.carTypes.Add(type);
db.SaveChanges();
}
if (db.carMarks.FirstOrDefault(t => t.Name.ToLower() == txtMark.Text.ToLower()) == null)
{
carMark mark = new carMark();
mark.Name = txtMark.Text;
db.carMarks.Add(mark);
db.SaveChanges();
}
if (db.carModels.FirstOrDefault(t => t.Name.ToLower() == txtModel.Text.ToLower()) == null)
{
carModel model = new carModel();
model.Name = txtModel.Text;
model.MarkId = db.carMarks.FirstOrDefault(m => m.Name == txtMark.Text).Id;
db.carModels.Add(model);
db.SaveChanges();
}
if (db.carColors.FirstOrDefault(t => t.Name.ToLower() == txtColor.Text.ToLower()) == null)
{
carColor color = new carColor();
color.Name = txtColor.Text;
db.carColors.Add(color);
db.SaveChanges();
}
if (db.Cars.FirstOrDefault(p => p.Plate == txtPlate.Text) == null)
{
Car car = new Car();
car.MarkId = db.carMarks.FirstOrDefault(m => m.Name == txtMark.Text).Id;
car.ModelId = db.carModels.FirstOrDefault(mo => mo.Name == txtModel.Text).Id;
car.TypeId = db.carTypes.FirstOrDefault(t => t.Name == txtType.Text).Id;
car.ColorId = db.carColors.FirstOrDefault(c => c.Name == txtColor.Text).Id;
car.Year = Convert.ToInt32(txtYear.Text);
car.SeatCapacity = Convert.ToInt32(numCap.Value);
car.Rate = Convert.ToDecimal(txtRate.Text);
car.Plate = txtPlate.Text;
car.IsAviable = true;
car.Note = rtbNote.Text;
car.AddedDate = DateTime.Now;
db.Cars.Add(car);
db.SaveChanges();
MessageBox.Show("Car added sucessfully!");
fillDgv(db.Cars.ToList());
Reset();
}
else
{
lblError.Text = "This plate already exists.";
}
}
else
{
lblError.Text = "Please fill all required(*) data!";
}
}
