public VersioModal GetVersioByID(int id) { VersioModal obj = new VersioModal(); obj.Id = id; return((VersioModal)ManageVersionField(ManageVersionAction.GetbyID, obj)); }
public ActionResult VersionUpdate(VersioModal obj1) { if (ModelState.IsValid) { vm.StartVesion = obj1.StartVesion; vm.EndVersion = obj1.EndVersion; vm.Id = obj1.Id; new VersionDataRepository().UpdateVersio(vm); return(RedirectToAction("VersionList")); } return(View()); }
public int DeleteVersio(int id) { try { VersioModal obj = new VersioModal(); obj.Id = id; var result = ManageVersionField(ManageVersionAction.Delete, obj); return(1); } catch (Exception) { //logging return(-1); } }
public ActionResult AddVersion(VersioModal obj) { if (ModelState.IsValid) { vm.Id = obj.Id; vm.StartVesion = obj.StartVesion; vm.EndVersion = obj.EndVersion; if (vm.Id == 0) { new VersionDataRepository().InsertVersio(vm); } ViewData.Model = vm; return(RedirectToAction("VersionList")); } return(View()); }
public int InsertVersio(VersioModal field) { return((int)ManageVersionField(ManageVersionAction.Insert, field)); }
private object ManageVersionField(ManageVersionAction dbAction, VersioModal entity) { try { object Id = System.DBNull.Value; object StartVersion = System.DBNull.Value; object EndVersion = System.DBNull.Value; object version = System.DBNull.Value; object Action = System.DBNull.Value; object Result = System.DBNull.Value; switch (dbAction) { case ManageVersionAction.Selectall: break; case ManageVersionAction.GetbyID: Id = entity.Id; break; case ManageVersionAction.Insert: StartVersion = entity.StartVesion; EndVersion = entity.EndVersion; version = String.Concat(StartVersion, EndVersion); break; case ManageVersionAction.Delete: Id = entity.Id; break; case ManageVersionAction.Update: Id = entity.Id; StartVersion = entity.StartVesion; EndVersion = entity.EndVersion; version = String.Concat(StartVersion, EndVersion); break; case ManageVersionAction.Version: break; default: break; } var conn = new SqlConnection(Conectionstring); conn.Open(); cmd = new SqlCommand("Version", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.Add("@Version_Id", SqlDbType.Int).Value = Id; cmd.Parameters.Add("@StartVersion_Nm", SqlDbType.VarChar).Value = StartVersion; cmd.Parameters.Add("@EndVersion", SqlDbType.VarChar).Value = EndVersion; cmd.Parameters.Add("@Version", SqlDbType.VarChar).Value = version; cmd.Parameters.Add("@Action", SqlDbType.VarChar).Value = dbAction.ToString(); switch (dbAction) { case ManageVersionAction.Selectall: List <VersioModal> lstdata = new List <VersioModal>(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { lstdata.Add(new VersioModal { Id = (int)reader["Id"], StartVesion = (string)reader["StartVersion"], EndVersion = (string)reader["PerVersion"], Version = (string)reader["Version"], }); } } Result = lstdata; conn.Close(); } break; case ManageVersionAction.GetbyID: VersioModal data = new VersioModal(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { data.Id = (int)reader["Id"]; data.StartVesion = (string)reader["StartVersion"]; data.EndVersion = (string)reader["PerVersion"]; data.Version = (string)reader["Version"]; } ; } } Result = data; conn.Close(); break; case ManageVersionAction.Version: List <VersioModal> data1 = new List <VersioModal>(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { data1.Add(new VersioModal { Id = (int)reader["Value"], Version = (string)reader["text"], }); } } Result = data1; conn.Close(); } break; case ManageVersionAction.Insert: try { cmd.ExecuteNonQuery(); Result = 1; } catch (Exception ex) { Result = -1; } break; case ManageVersionAction.Delete: try { cmd.ExecuteNonQuery(); Result = 1; } catch (Exception ex) { Result = -1; } break; case ManageVersionAction.Update: try { cmd.ExecuteNonQuery(); Result = 1; } catch (Exception ex) { Result = -1; } break; default: break; } return(Result); } catch (Exception ex) { throw ex; } }
public int UpdateVersio(VersioModal field) { return((int)ManageVersionField(ManageVersionAction.Update, field)); }
public List <VersioModal> GetAllVersioName() { VersioModal list = new VersioModal(); return((List <VersioModal>)ManageVersionField(ManageVersionAction.Version, list)); }
public List <VersioModal> GetAllVersio() { VersioModal list = new VersioModal(); return((List <VersioModal>)ManageVersionField(ManageVersionAction.Selectall, list)); }