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!"; } }