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