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)));
}
