public IHttpActionResult PostUserDetail([FromBody] pcms_User _user)
{
// int _userId = 0;
pcms_User objUser = new pcms_User();
try
{
pcms_BAL objBAL = new pcms_BAL();
objUser = objBAL.InsertUserDetail(_user);
}
catch (Exception ex)
{
throw ex;
}
return(Ok(objUser));
}
public pcms_User InsertUserDetail(pcms_User _user)
{
// var _userId = 0;
SqlCommand cmd = null;
try
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
con.Open();
cmd = new SqlCommand(null, con);
cmd.CommandText = "select count(*) as count from pcms_user where USER_ID=@USER_ID";
SqlParameter USER_ID = new SqlParameter("@USER_ID", SqlDbType.Int, 1024);
USER_ID.Value = _user.USER_ID;
cmd.Parameters.Add(USER_ID);
cmd.Prepare();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (Convert.ToInt16(dr[0]) > 0)
{
cmd = new SqlCommand(null, con);
cmd.CommandText = @"UPDATE pcms_user
SET USER_IP = @USER_IP
,USER_GENDER = @USER_GENDER
,USER_CITY = @USER_CITY
,USER_URL = @USER_URL
,USER_BROWSER = @USER_BROWSER
,USER_COUNTRY_NAME = @USER_COUNTRY_NAME
,USER_REGION = @USER_REGION
,USER_TIMEZONE = @USER_TIMEZONE
,USER_ZIP = @USER_ZIP
,USER_TYPE = @USER_TYPE
,COOKIE_CREATION_DATE = @COOKIE_CREATION_DATE
,INSERTED_BY = @INSERTED_BY
,INSERTED_DATE = @INSERTED_DATE
,UPDATED_BY = @UPDATED_BY
,UPDATED_DATE = @UPDATED_DATE
,TS_CNT = @TS_CNT
WHERE USER_ID=@USER_ID";
SqlParameter USER_IP = new SqlParameter("@USER_IP", SqlDbType.VarChar, 50);
SqlParameter USER_GENDER = new SqlParameter("@USER_GENDER", SqlDbType.NVarChar, 50);
SqlParameter USER_CITY = new SqlParameter("@USER_CITY", SqlDbType.NVarChar, 100);
SqlParameter USER_URL = new SqlParameter("@USER_URL", SqlDbType.VarChar);
SqlParameter USER_BROWSER = new SqlParameter("@USER_BROWSER", SqlDbType.VarChar, 50);
SqlParameter USER_COUNTRY_NAME = new SqlParameter("@USER_COUNTRY_NAME", SqlDbType.NVarChar, 100);
SqlParameter USER_REGION = new SqlParameter("@USER_REGION", SqlDbType.NVarChar, 50);
SqlParameter USER_TIMEZONE = new SqlParameter("@USER_TIMEZONE", SqlDbType.NVarChar, 100);
SqlParameter USER_ZIP = new SqlParameter("@USER_ZIP", SqlDbType.NVarChar, 10);
SqlParameter USER_TYPE = new SqlParameter("@USER_TYPE", SqlDbType.NVarChar, 16);
SqlParameter COOKIE_CREATION_DATE = new SqlParameter("@COOKIE_CREATION_DATE", SqlDbType.DateTime, 16);
SqlParameter INSERTED_BY = new SqlParameter("@INSERTED_BY", SqlDbType.NVarChar, 50);
SqlParameter INSERTED_DATE = new SqlParameter("@INSERTED_DATE", SqlDbType.DateTime, 16);
SqlParameter UPDATED_BY = new SqlParameter("@UPDATED_BY", SqlDbType.NVarChar, 50);
SqlParameter UPDATED_DATE = new SqlParameter("@UPDATED_DATE", SqlDbType.DateTime, -1);
SqlParameter TS_CNT = new SqlParameter("@TS_CNT", SqlDbType.Int, 16);
USER_IP.Value = _user.USER_IP;
USER_GENDER.Value = _user.USER_GENDER;
USER_CITY.Value = _user.USER_CITY;
USER_URL.Value = _user.USER_URL;
USER_BROWSER.Value = _user.USER_BROWSER;
USER_COUNTRY_NAME.Value = _user.USER_COUNTRY_NAME;
USER_REGION.Value = _user.USER_REGION;
USER_TIMEZONE.Value = _user.USER_TIMEZONE;
USER_ZIP.Value = _user.USER_ZIP;
USER_TYPE.Value = _user.USER_TYPE;
COOKIE_CREATION_DATE.Value = _user.COOKIE_CREATION_DATE;
INSERTED_BY.Value = _user.INSERTED_BY;
INSERTED_DATE.Value = _user.INSERTED_DATE;
UPDATED_BY.Value = _user.UPDATED_BY;
UPDATED_DATE.Value = _user.UPDATED_DATE;
TS_CNT.Value = _user.TS_CNT;
cmd.Parameters.Add(USER_IP);
cmd.Parameters.Add(USER_GENDER);
cmd.Parameters.Add(USER_CITY);
cmd.Parameters.Add(USER_URL);
cmd.Parameters.Add(USER_BROWSER);
cmd.Parameters.Add(USER_COUNTRY_NAME);
cmd.Parameters.Add(USER_REGION);
cmd.Parameters.Add(USER_TIMEZONE);
cmd.Parameters.Add(USER_ZIP);
cmd.Parameters.Add(USER_TYPE);
cmd.Parameters.Add(COOKIE_CREATION_DATE);
cmd.Parameters.Add(INSERTED_BY);
cmd.Parameters.Add(INSERTED_DATE);
cmd.Parameters.Add(UPDATED_BY);
cmd.Parameters.Add(UPDATED_DATE);
cmd.Parameters.Add(TS_CNT);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
else
{
cmd = new SqlCommand(null, con);
cmd.CommandText = @"insert into pcms_user(USER_IP,USER_GENDER,USER_CITY
,USER_URL,USER_BROWSER,USER_COUNTRY_NAME,USER_REGION
,USER_TIMEZONE,USER_ZIP,USER_TYPE,COOKIE_CREATION_DATE
,INSERTED_BY,INSERTED_DATE,UPDATED_BY,UPDATED_DATE
,TS_CNT)
values(@USER_IP,@USER_GENDER,@USER_CITY
,@USER_URL,@USER_BROWSER,@USER_COUNTRY_NAME,@USER_REGION
,@USER_TIMEZONE,@USER_ZIP,@USER_TYPE,@COOKIE_CREATION_DATE
,@INSERTED_BY,@INSERTED_DATE,@UPDATED_BY,@UPDATED_DATE
,@TS_CNT);SELECT SCOPE_IDENTITY();";
SqlParameter USER_IP = new SqlParameter("@USER_IP", SqlDbType.VarChar, 50);
SqlParameter USER_GENDER = new SqlParameter("@USER_GENDER", SqlDbType.NVarChar, 50);
SqlParameter USER_CITY = new SqlParameter("@USER_CITY", SqlDbType.NVarChar, 100);
SqlParameter USER_URL = new SqlParameter("@USER_URL", SqlDbType.VarChar, 1024);
SqlParameter USER_BROWSER = new SqlParameter("@USER_BROWSER", SqlDbType.VarChar, 50);
SqlParameter USER_COUNTRY_NAME = new SqlParameter("@USER_COUNTRY_NAME", SqlDbType.NVarChar, 100);
SqlParameter USER_REGION = new SqlParameter("@USER_REGION", SqlDbType.NVarChar, 50);
SqlParameter USER_TIMEZONE = new SqlParameter("@USER_TIMEZONE", SqlDbType.NVarChar, 100);
SqlParameter USER_ZIP = new SqlParameter("@USER_ZIP", SqlDbType.NVarChar, 10);
SqlParameter USER_TYPE = new SqlParameter("@USER_TYPE", SqlDbType.NVarChar, 16);
SqlParameter COOKIE_CREATION_DATE = new SqlParameter("@COOKIE_CREATION_DATE", SqlDbType.DateTime, -1);
SqlParameter INSERTED_BY = new SqlParameter("@INSERTED_BY", SqlDbType.NVarChar, 50);
SqlParameter INSERTED_DATE = new SqlParameter("@INSERTED_DATE", SqlDbType.DateTime, -1);
SqlParameter UPDATED_BY = new SqlParameter("@UPDATED_BY", SqlDbType.NVarChar, 50);
SqlParameter UPDATED_DATE = new SqlParameter("@UPDATED_DATE", SqlDbType.DateTime, -1);
SqlParameter TS_CNT = new SqlParameter("@TS_CNT", SqlDbType.Int, 16);
USER_IP.Value = _user.USER_IP;
USER_GENDER.Value = _user.USER_GENDER;
USER_CITY.Value = _user.USER_CITY;
USER_URL.Value = _user.USER_URL;
USER_BROWSER.Value = _user.USER_BROWSER;
USER_COUNTRY_NAME.Value = _user.USER_COUNTRY_NAME;
USER_REGION.Value = _user.USER_REGION;
USER_TIMEZONE.Value = _user.USER_TIMEZONE;
USER_ZIP.Value = _user.USER_ZIP;
USER_TYPE.Value = _user.USER_TYPE;
COOKIE_CREATION_DATE.Value = _user.COOKIE_CREATION_DATE;
INSERTED_BY.Value = _user.INSERTED_BY;
INSERTED_DATE.Value = _user.INSERTED_DATE;
UPDATED_BY.Value = _user.UPDATED_BY;
UPDATED_DATE.Value = _user.UPDATED_DATE;
//if (_user.UPDATED_DATE == null)
// UPDATED_DATE.Value = DBNull.Value;
//else
// UPDATED_DATE.Value = _user.UPDATED_DATE;
TS_CNT.Value = _user.TS_CNT;
cmd.Parameters.Add(USER_IP);
cmd.Parameters.Add(USER_GENDER);
cmd.Parameters.Add(USER_CITY);
cmd.Parameters.Add(USER_URL);
cmd.Parameters.Add(USER_BROWSER);
cmd.Parameters.Add(USER_COUNTRY_NAME);
cmd.Parameters.Add(USER_REGION);
cmd.Parameters.Add(USER_TIMEZONE);
cmd.Parameters.Add(USER_ZIP);
cmd.Parameters.Add(USER_TYPE);
cmd.Parameters.Add(COOKIE_CREATION_DATE);
cmd.Parameters.Add(INSERTED_BY);
cmd.Parameters.Add(INSERTED_DATE);
cmd.Parameters.Add(UPDATED_BY);
cmd.Parameters.Add(UPDATED_DATE);
cmd.Parameters.Add(TS_CNT);
cmd.Prepare();
// cmd.ExecuteNonQuery();
//_userId = command.ExecuteNonQuery();
_user.USER_ID = Convert.ToInt32(cmd.ExecuteScalar());
// return modified;
}
}
}
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
return(_user);
}
}
catch (Exception)
{
return(_user);
}
}
public pcms_User InsertUserDetail(pcms_User _user)
{
pcms_DAL objDAL = new pcms_DAL();
return(objDAL.InsertUserDetail(_user));
}
