public Int64 AddTranslator(Int64 Id, AddTranslator obj) { CommonHelper objCH = new CommonHelper(); long RndmNumbr = objCH.GetRandomNumber(100000, 999999); obj.Password = objCH.EncryptData(RndmNumbr); DataTable dt = objTDS.AddTranslator(Id, obj); if (dt != null && dt.Rows.Count > 0) { return(Convert.ToInt64(dt.Rows[0]["Id"])); } else { return(0); } }
public DataTable AddTranslator(Int64 Id, AddTranslator obj) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = Procedures.AddTranslator; sqlCommand.Parameters.AddWithValue("@UserId", Id); sqlCommand.Parameters.AddWithValue("@TranslatorId", obj.TranslatorId); sqlCommand.Parameters.AddWithValue("@FirstName", obj.FirstName); sqlCommand.Parameters.AddWithValue("@LastName", obj.LastName); sqlCommand.Parameters.AddWithValue("@Email", obj.Email); sqlCommand.Parameters.AddWithValue("@Mobile", obj.Mobile); sqlCommand.Parameters.AddWithValue("@IsActive", obj.Status); sqlCommand.Parameters.AddWithValue("@Languages", obj.LanguageIds); sqlCommand.Parameters.AddWithValue("@Password", obj.Password); sqlCommand.Parameters.AddWithValue("@IsWelcomeMailSent", obj.IsWelcomeMailSent); return(DAL.GetDataTable(ConfigurationHelper.connectionString, sqlCommand)); } }
public IHttpActionResult AddTranslator(Int64 Id, AddTranslator obj) { TranslatorBusinessService objTBS = new TranslatorBusinessService(); return(Ok(objTBS.AddTranslator(Id, obj))); }