public JsonResult SaveLanguagesData(LanguagesDTO languagesDetail) { var AllStatus = languagesData.AddLanguagesData(languagesDetail); return(new JsonResult { Data = AllStatus, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public Language CastToDAL(LanguagesDTO l) { return(new Language() { languageId = l.languageId, name = l.name }); }
private int UpdateLanguages(LanguagesDTO languages) { int LanguageId = 0; string updateProcedure = "[CreateLanguages]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (languages.LanguageId != 0) { updateCommand.Parameters.AddWithValue("@LanguageId", languages.LanguageId); } else { updateCommand.Parameters.AddWithValue("@LanguageId", 0); } if (!string.IsNullOrEmpty(languages.LanguageName)) { updateCommand.Parameters.AddWithValue("@LanguageName", languages.LanguageName); } else { updateCommand.Parameters.AddWithValue("@LanguagesName", DBNull.Value); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { int count = 0; connection.Open(); updateCommand.ExecuteNonQuery(); if (updateCommand.Parameters["@ReturnValue"].Value != DBNull.Value) { count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); } return(LanguageId); } catch (Exception ex) { log.logErrorMessage(""); log.logErrorMessage(ex.StackTrace); return(LanguageId); } finally { connection.Close(); } }
private LanguagesDTO AddLanguages(LanguagesDTO languages) { string insertProcedure = "[CreateLanguages]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (languages.LanguageId != 0) { insertCommand.Parameters.AddWithValue("@LanguageId", languages.LanguageId); } else { insertCommand.Parameters.AddWithValue("@LanguageId", 0); } if (!string.IsNullOrEmpty(languages.LanguageName)) { insertCommand.Parameters.AddWithValue("@LanguageName", languages.LanguageName); } else { insertCommand.Parameters.AddWithValue("@LanguagesName", DBNull.Value); } if (languages.CustId != 0) { insertCommand.Parameters.AddWithValue("@CustID", languages.CustId); } else { insertCommand.Parameters.AddWithValue("@CustID", 0); } if (languages.UserID != 0) { insertCommand.Parameters.AddWithValue("@UserID", languages.UserID); } else { insertCommand.Parameters.AddWithValue("@UserID", 0); } if (languages.IsActive) { insertCommand.Parameters.AddWithValue("@IsActive", languages.IsActive); } else { insertCommand.Parameters.AddWithValue("@IsActive", 0); } if (languages.Type != 0) { insertCommand.Parameters.AddWithValue("@StatementType", languages.Type); } else { insertCommand.Parameters.AddWithValue("@StatementType", 0); } insertCommand.Parameters.Add("@LanguageIdout", System.Data.SqlDbType.Int); insertCommand.Parameters["@LanguageIdout"].Direction = ParameterDirection.Output; insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { int count = 0; connection.Open(); insertCommand.ExecuteNonQuery(); if (insertCommand.Parameters["@ReturnValue"].Value != DBNull.Value) { count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); languages.Status = count; } if (count != 0 && languages.LanguageId == 0) { languages.LanguageId = System.Convert.ToInt32(insertCommand.Parameters["@LanguageIdout"].Value); } return(languages); } catch (Exception ex) { log.logErrorMessage(""); log.logErrorMessage(ex.StackTrace); return(languages); } finally { connection.Close(); } }
public List <dynamic> AddLanguagesData(LanguagesDTO languagesDetail) { List <dynamic> objDynamic = new List <dynamic>(); #region comment //var Data = JsonConvert.DeserializeObject<List<LanguagesDTO>>(languagesDetail.Languagesdet); //for (int i = 0; i < Data.Count; i++) //{ // languages = Data[i]; // if (!String.IsNullOrEmpty(languages.LanguageName)) // { // if (languages.IsChange) // { // if (!string.IsNullOrEmpty(UserID)) // { // languages.UserID = Convert.ToInt64(UserID); // } // if (languages.LanguageId != 0 ) // { // languages.Type = 2; // } // if (languages.IsDelete == true) // { // languages.Type = 3; // languages.IsActive = false; // } // AddLanguages(languages); // if (languages.Status == -99) // { // objDynamic.Add(languages.Status); // break; // } // else // { // objDynamic.Add(languages.Status); // } // } // } // } #endregion CustLanguages custLanguages = new CustLanguages(); LanguagesDTO languages = new LanguagesDTO(); try { switch (languagesDetail.Type) { case 1: { var Data = JsonConvert.DeserializeObject <List <LanguagesDTO> >(languagesDetail.Languagesdet); for (int i = 0; i < Data.Count; i++) { languages = Data[i]; if (languages.IsChange && languages.IsDelete) { languages.IsActive = false; languages.Type = 3; if (!string.IsNullOrEmpty(UserID)) { languages.UserID = Convert.ToInt64(UserID); } AddLanguages(languages); } } break; } case 2: { var Data = JsonConvert.DeserializeObject <List <CustLanguages> >(languagesDetail.Customerdet); Int64 val = languagesDetail.LanguageId; for (int i = 0; i < Data.Count; i++) { custLanguages = Data[i]; languages.CustId = custLanguages.CustId; languages.LanguageName = languagesDetail.LanguageName; if (!string.IsNullOrEmpty(UserID)) { languages.UserID = Convert.ToInt64(UserID); } if (val != 0) { languages.IsActive = custLanguages.IsCat; languages.Type = 2; languages.LanguageId = val; AddLanguages(languages); } else { languages.IsActive = custLanguages.IsCat; languages.Type = 1; languages.LanguageId = val; AddLanguages(languages); val = languages.LanguageId; if (languages.Status != 1) { break; } } } break; } } } catch (Exception ex) { } //AddLanguages(languages); objDynamic.Add(languages.Status); objDynamic.Add(GetLanguagesData(0)); return(objDynamic); }