//Data Insert in State Table
public ResponseModel InsertState(StateModel model)
{
string strResultState = "";
try
{
cmd = new SqlCommand("InsertState_Sp", con);
cmd.Parameters.Add("@StateName", SqlDbType.VarChar, 50).Value = model.StateName;
cmd.Parameters.Add("@CreatedBy", SqlDbType.BigInt).Value = model.CreatedBy;
cmd.Parameters.Add("@Result_StateId", SqlDbType.BigInt).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
strResultState = cmd.Parameters["@Result_StateId"].Value.ToString();
message = "Success";
if (con.State == ConnectionState.Open)
con.Close();
}
catch (Exception ex)
{
obj.Message = ex.Message;
ret = 0;
}
obj.Response = Convert.ToInt32(strResultState);
return obj;
}
//State will auto complete on dropdown list
public List<StateModel> AutoCompleteState(StateModel mymodel)
{
List<StateModel> model = new List<StateModel>();
try
{
SqlCommand cmd = new SqlCommand("AutoCompleteState_Sp", con);
cmd.Parameters.Add("@StateName", SqlDbType.NVarChar, 150).Value = mymodel.StateName;
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
model.Add(new StateModel
{
StateId = Convert.ToInt32(dr["StateId"]),
StateName = dr["StateName"].ToString(),
CreatedBy = Convert.ToInt32(dr["CreatedBy"]),
CreatedOn = Convert.ToDateTime(dr["CreatedOn"]),
ModifiedBy = Convert.ToInt32(dr["ModifiedBy"]),
ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"]),
IsActive = Convert.ToBoolean(dr["IsActive"]),
IsDelete = Convert.ToBoolean(dr["IsDelete"]),
});
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
catch (Exception ex)
{
obj.Message = ex.Message;
ret = 0;
}
return model;
// return Json(model, JsonRequestBehavior.AllowGet);
}
public ResponseModel InsertState(StateModel model)
{
State_Sp_Class obj = new State_Sp_Class();
return obj.InsertState(model);
}
//Data Insert in Organizaton Table
public ResponseModel InsertOrgAndUser(UserProfileModel model)
{
try
{
cmd = new SqlCommand("InsertOrgAndUser_Sp", con);
if (model.UserCityId == 0 && model.UserCity != null)
{
CityModel cityModel = new CityModel();
cityModel.CityName = model.UserCity;
cityModel.CreatedBy = model.CreatedBy;
ResponseModel responseModel = cityObj.InsertCity(cityModel);
model.UserCityId = responseModel.Response;
}
if (model.UserStateId == 0 && model.UserState != null)
{
StateModel model3 = new StateModel();
model3.StateName = model.UserState;
model3.CreatedBy = model.CreatedBy;
ResponseModel model1 = stateObj.InsertState(model3);
model.UserStateId = model1.Response;
}
if (model.OrgCityId == 0 && model.OrgCity != null)
{
CityModel cityModel = new CityModel();
cityModel.CityName = model.OrgCity;
cityModel.CreatedBy = model.CreatedBy;
ResponseModel responseModel = cityObj.InsertCity(cityModel);
model.OrgCityId = responseModel.Response;
}
if (model.OrgStateId == 0 && model.OrgState != null)
{
StateModel model3 = new StateModel();
model3.StateName = model.OrgState;
model3.CreatedBy = model.CreatedBy;
ResponseModel model1 = stateObj.InsertState(model3);
model.OrgStateId = model1.Response;
}
if (model.RoleId == 0 && model.RoleName != null)
{
RoleModel model3 = new RoleModel();
model3.RoleName = model.RoleName;
model3.CreatedByOrg_Id = model.OrgId;
model3.CreatedByUser_Id = model.CreatedBy;
ResponseModel model1 = InsertRole(model3);
model.RoleId = model1.Response;
}
//Organization_Tbl Fields
if (model.OrgId > 0)
cmd.Parameters.Add("@OrgId", SqlDbType.BigInt).Value = model.OrgId;
cmd.Parameters.Add("@Name", SqlDbType.VarChar, 400).Value = model.OrgName;
cmd.Parameters.Add("@Street", SqlDbType.NVarChar, 100).Value = model.OrgStreet;
if (model.OrgCityId > 0)
cmd.Parameters.Add("@CityId", SqlDbType.BigInt).Value = model.OrgCityId;
if (model.OrgStateId > 0)
cmd.Parameters.Add("@StateId", SqlDbType.BigInt).Value = model.OrgStateId;
cmd.Parameters.Add("@RegisteredAs", SqlDbType.VarChar, 50).Value = model.RegisteredAs;
cmd.Parameters.Add("@Logo", SqlDbType.NVarChar, 150).Value = model.Logo;
//User_Tbl Fields
if (model.UserId > 0)
cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = model.UserId;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 70).Value = model.UserFirstName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 70).Value = model.UserLastName;
cmd.Parameters.Add("@U_Street", SqlDbType.NVarChar, 100).Value = model.UserStreet;
if (model.UserCityId > 0)
cmd.Parameters.Add("@U_CityId", SqlDbType.BigInt).Value = model.UserCityId;
if (model.UserStateId > 0)
cmd.Parameters.Add("@U_StateId", SqlDbType.BigInt).Value = model.UserStateId;
cmd.Parameters.Add("@ProfilePhoto", SqlDbType.NVarChar).Value = model.ProfilePhoto;
cmd.Parameters.Add("@RoleId", SqlDbType.Int).Value = model.RoleId;
cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 200).Value = model.UserName;
cmd.Parameters.Add("@EmailId", SqlDbType.NVarChar, 150).Value = model.UserEmailId;
cmd.Parameters.Add("@MobileNo", SqlDbType.NVarChar, 13).Value = model.UserMobileNo;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar).Value = PasswordSecurity.Encrypt(model.Password);//Password Encryption
cmd.Parameters.Add("@U_IsActive", SqlDbType.Bit).Value = model.User_IsActive;
cmd.Parameters.Add("@U_IsDelete", SqlDbType.Bit).Value = model.User_IsDelete;
//Common Fields
cmd.Parameters.Add("@CreatedBy", SqlDbType.BigInt).Value = model.CreatedBy;
cmd.Parameters.Add("@IsActive", SqlDbType.Bit).Value = model.IsActive;
cmd.Parameters.Add("@IsDelete", SqlDbType.Bit).Value = model.IsDelete;
cmd.Parameters.Add("@Result_OrgId", SqlDbType.BigInt).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Result_UserId", SqlDbType.BigInt).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
message = "Success";
if (con.State == ConnectionState.Open)
con.Close();
}
catch (Exception ex)
{
obj.Message = ex.Message;
ret = 0;
}
obj.Response = ret;
return obj;
}
public List<StateModel> AutoCompleteState(StateModel model)
{
return obj.AutoCompleteState(model);
}