public int DALFriendRelationUpdatePrefix(CommonSqlQueryCode ur)
{
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[4];
par[0] = new SqlParameter("@frnrelUserId", ur.frnrelUserId);
par[1] = new SqlParameter("@FriendPrefix", ur.FrnrelPrefix);
par[2] = new SqlParameter("@frnrelFriendId", ur.frnrelFriendId);
par[3] = new SqlParameter("@status", 7);
par[3].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "FriendRelationUpdatePrefix", par);
status = (int)par[4].Value;
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(status);
}
public int BLLTestUserFriendRelative(CommonSqlQueryCode ur)
{
SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
int flag = 0;
try
{
string sql = "select FriRelId from friendRelationmaster where Userid='" + ur.frnrelUserId + "'and FriendId='" + ur.frnrelFriendId + "'";
string newflag = ccr.ExecuteScalar(sql);
if (newflag.ToString() != "")
{
flag = Convert.ToInt32(ccr.ExecuteScalar(sql));
}
if (flag > 0)
{
flag = 1;
}
else
{
flag = 0;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con1.Close();
}
return(flag);
}
public int DALInsertUserRegistrationInitial(CommonSqlQueryCode ur)
{
SqlConnection cons2 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
int status = 0;
try
{
cons2.Open();
//SqlParameter[] par = new SqlParameter[18];
//par[0] = new SqlParameter("@usrUserId", ur.usrUserId);
//par[1] = new SqlParameter("@usrMobileNo", ur.usrMobileNo);
//par[2] = new SqlParameter("@usrAltMobileNo", ur.usrAltMobileNo);
//par[3] = new SqlParameter("@usrAddress", ur.usrAddress);
//par[4] = new SqlParameter("@usrPassword", ur.usrPasssword);
//par[5] = new SqlParameter("@usrFirstName", ur.usrFirstName);
//par[6] = new SqlParameter("@usrLastName", ur.usrLastName);
//par[7] = new SqlParameter("@usrGender", ur.usrGender);
//par[8] = new SqlParameter("@usrCityId", ur.usrCityId);
//par[9] = new SqlParameter("@usrFriendGroup", ur.frnrelGroup);
//par[10] = new SqlParameter("@usrPIN", ur.usrPIN);
//par[11] = new SqlParameter("@usrDOB", ur.usrDOB);
//par[12] = new SqlParameter("@FaxNo", ur.FaxNo);
//par[13] = new SqlParameter("@usrPhoneNumber", ur.usrPhoneNo);
//par[14] = new SqlParameter("@OfficeNo", ur.OfficeNo);
//par[15] = new SqlParameter("@usrEmailId", ur.usrEmailId);
//par[16] = new SqlParameter("@strDevId", "");
//par[17] = new SqlParameter("@Status", 17);
//par[17].Direction = ParameterDirection.Output;
//SqlHelper.ExecuteNonQuery(cons2, CommandType.StoredProcedure, "UserRegistrationIntialInsert", par);
//status = (int)par[17].Value;
string str = " insert into UserMaster(usrUserId,usrMobileNo,usrAddress,usrPassword,usrFirstName,usrLastName,usrCityId,usrGender,usrFriRelGroup)values('"+ ur.usrUserId + "','" + ur.usrMobileNo + "',N'" + ur.usrAddress + "','" + ur.usrPasssword + "',N'" + ur.usrFirstName + "',N'" + ur.usrLastName + "','" + ur.usrCityId + "','" + ur.usrGender + "','" + ur.frnrelGroup + "')";
status = ccr.ExecuteNonQuery(str);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cons2.Close();
}
return(status);
}
public int BLLInsertUserFriendRelative(CommonSqlQueryCode ur)
{
SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
int flag;
try
{
string sql = " insert into FriendRelationMaster(UserId,FriendId,FriRelName,Relation,friendGroup,FriendPrefix,senderid,FR1,FR2," +
"FR3,FR4,FR5,FR6,FR7,FR8,FR9,FR10,FR11,FR12,FR13,FR14,FR15,FR16,FR17,FR18," +
" FR19,FR20,FR21,FR22,FR23,FR24,FR25,FR26,FR27,FR28,FR29,FR30) " +
"values('" + ur.frnrelUserId + "','" + ur.frnrelFriendId + "',N'" + ur.usrFirstName + "" + ur.usrLastName + "',N'" + ur.frnrelRelation + "',N'" + ur.frnrelGroup + "','" + ur.FrnrelPrefix + "','" + ur.Senderid + "'," +
"N'" + ur.FR1 + "',N'" + ur.FR2 + "',N'" + ur.FR3 + "',N'" + ur.FR4 + "',N'" + ur.FR5 + "',N'" + ur.FR6 + "',N'" + ur.FR7 + "',N'" + ur.FR8 + "'," +
"N'" + ur.FR9 + "',N'" + ur.FR10 + "',N'" + ur.FR11 + "',N'" + ur.FR12 + "',N'" + ur.FR13 + "',N'" + ur.FR14 + "'," +
"N'" + ur.FR15 + "',N'" + ur.FR16 + "',N'" + ur.FR17 + "',N'" + ur.FR18 + "',N'" + ur.FR19 + "',N'" + ur.FR20 + "',N'" + ur.FR21 + "'," +
"N'" + ur.FR22 + "',N'" + ur.FR23 + "',N'" + ur.FR24 + "',N'" + ur.FR25 + "',N'" + ur.FR26 + "',N'" + ur.FR27 + "'," +
"N'" + ur.FR28 + "',N'" + ur.FR29 + "',N'" + ur.FR30 + "')";
flag = ccr.ExecuteNonQuery(sql);
if (flag == 1)
{
flag = 1;
}
else
{
flag = 0;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con1.Close();
}
return(flag);
}
public int BLLUpdateUserFriendRelative(CommonSqlQueryCode ur)
{
SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
int flag;
try
{
string sql = "update FriendRelationMaster set FR1='" + ur.FR1 + "',FR2='" + ur.FR2 + "'," +
"FR3='" + ur.FR3 + "',FR4='" + ur.FR4 + "',FR5='" + ur.FR5 + "',FR6='" + FR6 + "',FR7='" + ur.FR7 + "',FR8='" + ur.FR8 + "',FR9='" + ur.FR9 + "',FR10='" + ur.FR10 + "'," +
"FR11='" + ur.FR11 + "',FR12='" + ur.FR12 + "',FR13='" + ur.FR13 + "',FR14='" + ur.FR14 + "',FR15='" + ur.FR15 + "'," +
"FR16='" + ur.FR16 + "',FR17='" + ur.FR17 + "',FR18='" + ur.FR18 + "'," +
" FR19='" + ur.FR19 + "',FR20='" + ur.FR20 + "',FR21='" + ur.FR21 + "'," +
"FR22='" + ur.FR22 + "',FR23='" + ur.FR23 + "',FR24='" + ur.FR24 + "',FR25='" + ur.FR25 + "',FR26='" + ur.FR26 + "',FR27='" + ur.FR27 + "',FR28='" + ur.FR28 + "',FR29='" + ur.FR29 + "',FR30='" + ur.FR30 + "'" +
" where UserId='" + ur.frnrelUserId + "' and FriendId='" + ur.frnrelFriendId + "' ";
flag = ccr.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
public int BLLPrefixUpdate(CommonSqlQueryCode ur)
{
status = ur.DALuserPrefix(ur);
return(status);
}
