/// <summary> /// Save wrinkles and distnces in database /// </summary> /// <param name="distances">Wrinkles and distances</param> public void saveToDbDistanceAndWrinkleBased(List <EmotionDataModel> distances) { Emotion_Training_distances obj; List <Emotion_Training_distances> features = new List <Emotion_Training_distances>(); emotiondbEntities1 db = new emotiondbEntities1(); foreach (EmotionDataModel model in distances) { obj = new Emotion_Training_distances(); obj.LEB1_CPLE1 = model.LEB1_CPLE1; obj.LEB2_CPLE2 = model.LEB2_CPLE2; obj.REB1_CPRE1 = model.REB1_CPRE1; obj.REB2_CPRE2 = model.REB2_CPRE2; obj.OPEN_LE1 = model.OPEN_LE1; obj.OPEN_LE2 = model.OPEN_LE2; obj.OPEN_RE1 = model.OPEN_RE1; obj.OPEN_RE2 = model.OPEN_RE2; obj.OPEN_MO1 = model.OPEN_MO1; obj.OPEN_MO2 = model.OPEN_MO2; obj.OPEN_MO3 = model.OPEN_MO3; obj.EXP_MO = model.EXP_MO; obj.NS_LPLIP = model.NS_LPLIP; obj.NS_RPLIP = model.NS_RPLIP; obj.betweenEyesWrinkles = model.betweenEyesWrinkles; obj.noseWrinkles = model.noseWrinkles; obj.Label = model.Label; features.Add(obj); } db.Emotion_Training_distances.AddRange(features); db.SaveChanges(); }
public void saveToDbDistanceAndWrinkleBased(List <EmotionDataModel> distances) { Emotion_Training_distances obj; List <Emotion_Training_distances> features = new List <Emotion_Training_distances>(); emotiondbEntities1 db = new emotiondbEntities1(); foreach (EmotionDataModel model in distances) { obj = new Emotion_Training_distances(); obj.LEB1_CPLE1 = model.LEB1_CPLE1; obj.LEB2_CPLE2 = model.LEB2_CPLE2; obj.REB1_CPRE1 = model.REB1_CPRE1; obj.REB2_CPRE2 = model.REB2_CPRE2; obj.OPEN_LE1 = model.OPEN_LE1; obj.OPEN_LE2 = model.OPEN_LE2; obj.OPEN_RE1 = model.OPEN_RE1; obj.OPEN_RE2 = model.OPEN_RE2; obj.OPEN_MO1 = model.OPEN_MO1; obj.OPEN_MO2 = model.OPEN_MO2; obj.OPEN_MO3 = model.OPEN_MO3; obj.EXP_MO = model.EXP_MO; obj.NS_LPLIP = model.NS_LPLIP; obj.NS_RPLIP = model.NS_RPLIP; obj.betweenEyesWrinkles = model.betweenEyesWrinkles; obj.noseWrinkles = model.noseWrinkles; obj.Label = model.Label; features.Add(obj); } db.Emotion_Training_distances.AddRange(features); db.SaveChanges(); //System.Data.SqlClient.SqlConnection sqlConnection1 = //new System.Data.SqlClient.SqlConnection(Constant.emotionDataConnectionString); //System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); //cmd.CommandType = System.Data.CommandType.Text; //cmd.CommandText = "INSERT Emotion_Training_distances (LEB1_CPLE1,LEB2_CPLE2 ,REB1_CPRE1,REB2_CPRE2,OPEN_LE1,OPEN_LE2,OPEN_RE1,OPEN_RE2,EXP_MO ,OPEN_MO1,OPEN_MO2,OPEN_MO3,NS_LPLIP,NS_RPLIP,betweenEyesWrinkles,noseWrinkles,Label) VALUES"; //foreach (EmotionDataModel emotionDataObject in distances) //{ // cmd.CommandText += "(" + emotionDataObject.LEB1_CPLE1 + "," + emotionDataObject.LEB2_CPLE2 + "," + emotionDataObject.REB1_CPRE1 + "," + emotionDataObject.REB2_CPRE2 + "," + emotionDataObject.OPEN_LE1 + "," + emotionDataObject.OPEN_LE2 + "," + emotionDataObject.OPEN_RE1 + "," + emotionDataObject.OPEN_RE2 + "," + emotionDataObject.EXP_MO + "," + emotionDataObject.OPEN_MO1 + "," + emotionDataObject.OPEN_MO2 + "," + emotionDataObject.OPEN_MO3 + "," + emotionDataObject.NS_LPLIP + "," + emotionDataObject.NS_RPLIP + "," + emotionDataObject.betweenEyesWrinkles + "," + emotionDataObject.noseWrinkles + ",'" + emotionDataObject .Label+ "')"; // if (distances.IndexOf(emotionDataObject) < distances.Count - 1) // { // cmd.CommandText += ","; // } //} //cmd.Connection = sqlConnection1; //sqlConnection1.Open(); //cmd.ExecuteNonQuery(); //sqlConnection1.Close(); }