// コンストラクタ
public ConfigurePincodeViewModel(DialogService dialogService, AddAccountService addAccountModel)
{
// DI
_dialogService = dialogService;
_addAccountService = addAccountModel;
// バリデーションを有効化する
Pincode.SetValidateAttribute(() => Pincode);
// Pincodeが入力されているときのみ「次へ」を押せるようにする
NextCommand = Pincode
.ObserveHasErrors
.Select(x => !x)
.ToReactiveCommand()
.AddTo(Disposables);
// 「次へ」が押されたらPinコードの認証を開始する
NextCommand.Subscribe(() =>
{
_addAccountService.ConfigureAccessTokens(Pincode.Value);
_dialogService.CloseConfigurePincodeView();
_dialogService.CloseConfigureApiKeyView();
})
.AddTo(Disposables);
}
public List <APIResponse> InsertPincode(Pincode obj)
{
List <APIResponse> responseList = new List <APIResponse>();
APIResponse responseObj = new APIResponse();
//First input parameter
var cityID = new SqlParameter
{
ParameterName = "@cityID",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Input,
Value = obj.city_id
};
//Second input parameter
var pincode = new SqlParameter
{
ParameterName = "@pincode",
SqlDbType = SqlDbType.VarChar,
Direction = ParameterDirection.Input,
Value = obj.pincode,
Size = 500
};
//third out parameter
var responseMsg = new SqlParameter
{
ParameterName = "@responseMsg",
SqlDbType = SqlDbType.VarChar,
Direction = ParameterDirection.Output,
Size = 500
};
var responseCode = new SqlParameter
{
ParameterName = "@responseCode",
SqlDbType = SqlDbType.VarChar,
Direction = ParameterDirection.Output,
Size = 500
};
string SQLString = "EXEC [dbo].[USP_AddPincode] @pincode, @cityID, @responseMsg OUT, @responseCode OUT";
var result = _dbContext.Database.ExecuteSqlCommand(SQLString, pincode, cityID, responseMsg, responseCode);
responseObj.responseMsg = (string)responseMsg.Value;
responseObj.responseCode = (int)responseCode.Value;
responseList.Add(responseObj);
return(responseList);
}
protected void btSave_Click(object sender, EventArgs e)
{
Pincode pin = new Pincode();
pin.AreaOfCity = txtarea.Text;
pin.CityIDF = int.Parse(ddcity.SelectedValue);
pin.StateIDF = int.Parse(ddstate.SelectedValue);
pin.IsActive = cbIsActive.Checked;
MEMBERS.SQLReturnValue mRes;
mRes = Pincode.Insert_Pincode(pin);
if (mRes.ValueFromSQL == 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true);
}
ClearCaching.ClearControls(PincodePanel);
}
public void MarkAsModified(Pincode item)
{
Entry(item).State = EntityState.Modified;
}
public void Update()
{
string strsql = "update Branch set " + "CompanyId= " + CompanyId + ", " + "BranchName= '" + BranchName.Replace("'", "''") + "', " + "AddressLine1= '" + AddressLine1.Replace("'", "''") + "', " + "AddressLine2= '" + AddressLine2.Replace("'", "''") + "', " + "CityId= " + CityId + ", " + "Pincode= '" + Pincode.Replace("'", "''") + "', " + "StateId= " + StateId + ", " + "CountryId= " + CountryId + ", " + "PhoneNumber1= '" + PhoneNumber1.Replace("'", "''") + "', " + "PhoneNumber2= '" + PhoneNumber2.Replace("'", "''") + "', " + "EmailId1= '" + EmailId1.Replace("'", "''") + "', " + "EmailId2= '" + EmailId2.Replace("'", "''") + "' " + " where ID =" + Id;
SqlConnection ObjConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyJobPortal"].ConnectionString);
ObjConnection.Open();
SqlCommand ObjCommand = new SqlCommand(strsql, ObjConnection);
ObjCommand.ExecuteNonQuery();
ObjConnection.Dispose();
ObjCommand.Dispose();
}
public ActionResult Card(PinViewModel Pin)
{
for (int counter = 1; counter <= Pin.Quantity; counter++)
{
int length = Pin.Digit;
string guidResult = System.Guid.NewGuid().ToString();
// Remove the hyphens
guidResult = guidResult.Replace("-", string.Empty);
// Make sure length is valid
if (length <= 0 || length > guidResult.Length)
{
throw new ArgumentException("Length must be between 1 and " + guidResult.Length);
}
// Return the first length bytes
ViewBag.Number = guidResult.Substring(1, length).ToUpper();
//*********************************
int limit = 1000000;
string SerialNo;
var maxValue = "";
if (Pin.StartFrom == null)
{
maxValue = db.Pincodes.OrderByDescending(x => x.PincodeId).Where(x => x.SerialNumber.Contains(Pin.SerialCode.ToUpper())).FirstOrDefault().SerialNumber;
}
else
{
maxValue = Pin.SerialCode.ToUpper() + "/" + Pin.StartFrom;
}
var defaultnumber = Pin.SerialCode.ToUpper() + "/" + "000000";
if (maxValue == null)
{
maxValue = defaultnumber;
}
maxValue = maxValue.Substring(5, 6);
int rst = int.Parse(maxValue);
int NewNumber = limit + rst + 1;
string val = NewNumber.ToString();
val = val.Substring(1, 6);
SerialNo = Pin.SerialCode.ToUpper() + "/" + val;
//SerialNo = "SEMB/" + val;
Pin.StartFrom = null;
var year = DateTime.Now.Year;
//**************************
Pincode cardNumber = db.Pincodes.Create();
cardNumber.PinNumber = guidResult.Substring(0, length).ToUpper();
cardNumber.SerialNumber = SerialNo;
cardNumber.BatchNumber = year.ToString() + Pin.BatchNumber.ToUpper();
cardNumber.IsDisenabled = false;
cardNumber.DateCreated = DateTime.Now;
cardNumber.UserDetails = User.Identity.Name;
cardNumber.Usage = 3;
db.Pincodes.Add(cardNumber);
db.SaveChanges();
ViewBag.Success = Pin.Quantity;
TempData["Check"] = "Ok";
}
return(RedirectToAction("Card", new { id = ViewBag.Success, batch = Pin.BatchNumber.ToUpper() }));
}
private bool CheckData(DataTable dt)
{
int TotalCount = 0, SuccessCount = 0, FailCount = 0;
string Message = string.Empty;
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TotalCount++;
bool IsValid = true;
int CountryId = 0, StateId = 0, CityId = 0;
string Connecter = " in Record-" + TotalCount.ToString() + ".<br />";
#region Value Initialization
CountryName = dt.Rows[i][CountryNameColumn].ToString().Trim();
StateName = dt.Rows[i][StateNameColumn].ToString().Trim();
CityName = dt.Rows[i][CityNameColumn].ToString().Trim();
AreaName = dt.Rows[i][AreaNameColumn].ToString().Trim();
#endregion
#region Check Country Name
if (IsValid)
{
if (CountryName.zIsNullOrEmpty())
{
Message += CS.Arrow + "Country Name Is Empty" + Connecter;
IsValid = false;
}
}
if (IsValid)
{
var lstCountry = new Country()
{
CountryName = CountryName.ToLower(), eStatus = (int)eStatus.Active,
}.SelectList <Country>();
if (lstCountry.Count == 0)
{
Message += CS.Arrow + "Country is Invalid" + Connecter;
IsValid = false;
}
else
{
CountryId = lstCountry[0].CountryId.Value;
}
}
#endregion
#region Check State Name
if (IsValid)
{
if (StateName.zIsNullOrEmpty())
{
Message += CS.Arrow + "State Name Is Empty" + Connecter;
IsValid = false;
}
}
if (IsValid)
{
var lstState = new State()
{
StateName = StateName.ToLower(), CountryId = CountryId, eStatus = (int)eStatus.Active
}.SelectList <State>();
if (lstState.Count == 0)
{
Message += CS.Arrow + "State is Invalid" + Connecter;
IsValid = false;
}
else
{
StateId = lstState[0].StateId.Value;
}
}
#endregion
#region Check City Name
if (IsValid)
{
if (CityName.zIsNullOrEmpty())
{
Message += CS.Arrow + "City Name Is Empty" + Connecter;
IsValid = false;
}
}
if (IsValid)
{
var lstCity = new City()
{
CityName = CityName.ToLower(), StateId = StateId, eStatus = (int)eStatus.Active
}.SelectList <City>();
if (lstCity.Count == 0)
{
Message += CS.Arrow + "City is Invalid" + Connecter;
IsValid = false;
}
else
{
CityId = lstCity[0].StateId.Value;
}
}
#endregion
#region Check Area Name
if (IsValid)
{
if (AreaName.zIsNullOrEmpty())
{
Message += CS.Arrow + "Area Name Is Empty" + Connecter;
IsValid = false;
}
}
if (IsValid)
{
string RepeateColumn = string.Empty;
if (CU.IsRepeateExcelRow(dt, i, AreaName, AreaNameColumn, CityName, CityNameColumn, StateName, StateNameColumn, ref RepeateColumn))
{
Message += CS.Arrow + "Area " + AreaName + " is Repeating in Record-" + RepeateColumn;
IsValid = false;
}
}
if (IsValid)
{
DataTable dtAreaName = new Query()
{
CountryId = CountryId,
StateId = StateId,
CityId = CityId,
AreaName = AreaName,
eStatusNot = (int)eStatus.Delete
}.Select(eSP.qry_Area);
if (dtAreaName.Rows.Count > 0 && !chkReplace.Checked)
{
string Status = dtAreaName.Rows[0][CS.eStatus].zToInt().Value == (int)eStatus.Deactive ? "(Deactive)" : string.Empty;
Message += CS.Arrow + AreaName + " Area is already exist" + Status + "." + Connecter;
IsValid = false;
}
}
#endregion
#region Check Pincode
if (!Pincode.zIsNullOrEmpty())
{
if (IsValid)
{
string RepeateColumn = string.Empty;
if (CU.IsRepeateExcelRow(dt, i, Pincode, PincodeColumn, string.Empty, null, string.Empty, null, ref RepeateColumn))
{
Message += CS.Arrow + "Pincode " + Pincode + " is Repeating in Record-" + RepeateColumn;
IsValid = false;
}
}
if (IsValid)
{
DataTable dtAreaPincode = new Query()
{
Pincode = Pincode,
eStatusNot = (int)eStatus.Delete
}.Select(eSP.qry_Area);
if (dtAreaPincode.Rows.Count > 0 && !chkReplace.Checked)
{
string Status = dtAreaPincode.Rows[0][CS.eStatus].zToInt().Value == (int)eStatus.Deactive ? "(Deactive)" : string.Empty;
Message += CS.Arrow + Pincode + " Pincode is already exist" + Status + "." + Connecter;
IsValid = false;
}
}
}
#endregion
if (IsValid)
{
SuccessCount++;
}
else
{
FailCount++;
if (FailCount >= 10)
{
break;
}
}
}
}
catch (Exception ex)
{
CU.ZMessage(eMsgType.Error, string.Empty, ex.Message, 0);
return(false);
}
if (FailCount == 0)
{
return(true);
}
else
{
CU.SetErrorExcelMessage(Message, SuccessCount, FailCount);
return(false);
}
}
public void TrimData()
{
if (Name == null)
{
Name = "";
}
if (Address == null)
{
Address = "";
}
if (City == null)
{
City = "";
}
if (Pincode == null)
{
Pincode = "";
}
if (State == null)
{
State = "";
}
if (MaxAdultCount < 0)
{
MaxAdultCount = 0;
}
if (MaxChildrenCount < 0)
{
MaxChildrenCount = 0;
}
if (MaxRoomBookingDaysFromOnlinePortal < 0)
{
MaxRoomBookingDaysFromOnlinePortal = 0;
}
if (MaxRoomCountForSingleBookingFromOnlinePortal < 0)
{
MaxRoomCountForSingleBookingFromOnlinePortal = 0;
}
if (PriorDaysCountForOnlinePortal < 0)
{
PriorDaysCountForOnlinePortal = 0;
}
if (DaysCountForNextBookingFromOnlinePortal < 0)
{
DaysCountForNextBookingFromOnlinePortal = 0;
}
Name = Name.Trim().ToUpper();
Address = Address.Trim();
City = City.Trim();
Pincode = Pincode.Trim();
State = State.Trim();
}
