public ActionResult IsUnique(Models.UniqueViewModel model) { bool result = true; // create sql statement StringBuilder sql = new StringBuilder("Select Count(0) From " + model.tablename + " Where"); // for update if (model.id != null) { sql.Append(" Name <> " + model.id + " And"); } // for child rows if (model.parentColumn != null) { sql.Append(" " + model.parentColumn + " = " + model.parentId + " And"); } // basic filter columns for (var i = 0; i < model.columns.Length; i++) { if (i != 0) { sql.Append(" And"); } sql.Append(" " + model.columns[i] + " = '" + model.values[i] + "'"); } System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HrContext"].ConnectionString); try { conn.Open(); System.Data.SqlClient.SqlCommand comm = new System.Data.SqlClient.SqlCommand(sql.ToString(), conn); System.Data.SqlClient.SqlDataReader reader = comm.ExecuteReader(System.Data.CommandBehavior.SingleResult); if (reader.Read()) { result = reader.GetValue(0).ToString() == "0"; } reader.Close(); comm.Dispose(); } catch (System.Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } finally { if (conn != null) { conn.Close(); conn.Dispose(); } } return(Json(result, JsonRequestBehavior.AllowGet)); }
private bool Unique(Models.UniqueViewModel model) { // create sql statement StringBuilder sql = new StringBuilder("Select Count(1) From " + model.tablename + " Where"); // for update if (model.id != null) { sql.Append(" Id <> '" + model.id + "' And"); } // for child rows if (model.IsLocal) { sql.Append(" (" + model.parentColumn + " = '" + model.parentId + "' Or " + model.parentColumn + " is null) And"); } else if (model.parentColumn != null) { sql.Append(" " + model.parentColumn + " = '" + model.parentId + "' And"); } // basic filter columns for (var i = 0; i < model.columns.Length; i++) { if (i != 0) { sql.Append(" And"); } sql.Append(" " + model.columns[i] + " = '" + model.values[i] + "'"); } if (model.tablename == "Currencies") { sql = sql.Replace("Id", "Code"); } return(_hrUnitOfWork.PagesRepository.GetIntResultFromSql(sql.ToString()) == 0); }
public JsonResult IsUniqueP(Models.UniqueViewModel model) { return(Json(Unique(model))); }
public JsonResult IsUnique(Models.UniqueViewModel model) { return(Json(Unique(model), JsonRequestBehavior.AllowGet)); }