public IActionResult SaveTermsAndCondition(ListModel objList)
{
List <TermsAndCondition> objTermsAndCondition = new List <TermsAndCondition>();
foreach (TermsAndCondition obj in objList.objTermsAndCondition)
{
obj.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
if (obj.ConditionCode_PK == null)
{
obj.IsNew = false;
}
else
{
obj.IsNew = true;
}
objTermsAndCondition.Add(obj);
}
string Vmsg = _termsConditionRepository.SaveTermsAndCondition(objTermsAndCondition);
return(Ok(new
{
message = Vmsg
}));
}
private string GetOrderBy(string sql, string entity, string primaryKey, List <Result> list, Order order)
{
if (order != null && !string.IsNullOrEmpty(order.Field))
{
if (!string.IsNullOrEmpty(primaryKey))
{
sql = Regex.Replace(sql, @"ORDER\s+BY", "ORDER BY");
if (sql.LastIndexOf("ORDER BY", StringComparison.Ordinal) == -1)
{
sql += " ORDER BY " +
(string.IsNullOrEmpty(entity) ? primaryKey : string.Format("{0}.{1}", entity, primaryKey));
}
}
}
try
{
CommonValidation.ExecuteSql(sql);
}
catch (Exception e)
{
list.Add(new Result("排序语句执行出错", string.Format("{0}\n\r{1}", e.Message, sql), Level.Error, GetType()));
}
return(sql);
}
private static bool NoAliasSqlCustom(string sql)
{
if (!string.IsNullOrEmpty(sql))
{
string temp = CommonValidation.GetFilter(sql);
using (SqlConnection connection = new SqlConnection(DbAccessManager.Connectstring))
{
connection.Open();
try
{
SqlCommand createCommand = new SqlCommand(temp, connection);
using (SqlDataReader sqlReader = createCommand.ExecuteReader())
{
for (int index = 0; index < sqlReader.FieldCount; index++)
{
if (string.IsNullOrEmpty(sqlReader.GetName(index)))
{
return(true);
}
}
}
}
catch (SqlException ex)
{
throw ex;
}
}
}
return(false);
}
public IncrementsController(IIncrementsLogic incrementsLogic, IncrementsValidation incrementsValidation, ICommonLogic commonLogic, CommonValidation commonValidation)
{
_incrementsLogic = incrementsLogic;
_incrementsValidation = incrementsValidation;
_commonLogic = commonLogic;
_commonValidation = commonValidation;
}
public IActionResult SaveSupplierInvoice(SupplierInvoice objSupplierInvoice)
{
if (!String.IsNullOrEmpty(objSupplierInvoice.InvoiceCode_PK))
{
objSupplierInvoice.IsNew = false;
}
else
{
objSupplierInvoice.IsNew = true;
}
objSupplierInvoice.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
objSupplierInvoice.InvoiceDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
foreach (SupplierInvoiceLine objSupplierInvoiceLine in objSupplierInvoice.SupplierInvoiceLine_VW)
{
objSupplierInvoiceLine.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
objSupplierInvoiceLine.ActionType = objSupplierInvoice.ActionType;
objSupplierInvoiceLine.UserCode = objSupplierInvoice.UserCode;
objSupplierInvoiceLine.CompanyCode_FK = objSupplierInvoice.CompanyCode_FK;
}
string Vmsg = _supplierInvoiceRepository.SaveSupplierInvoice(objSupplierInvoice);
return(Ok(new
{
message = Vmsg
}));
}
public IActionResult SaveSupplier(SupplierInfo objsupplierInfo)
{
objsupplierInfo.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
//objsupplierInfo.EnlistmentDate = CommonValidation.FormatDate(objsupplierInfo.EnlistmentDate, "yyyy-mm-dd", "dd-mm-yyyy");
foreach (SupplierAttachment supplierAttachment in objsupplierInfo.SupplierAttachmentList_VW)
{
//supplierAttachment.IssueDate = CommonValidation.FormatDate(supplierAttachment.IssueDate, "yyyy-mm-dd", "dd-mm-yyyy");
//supplierAttachment.ExpiryDate = CommonValidation.FormatDate(supplierAttachment.ExpiryDate, "yyyy-mm-dd", "dd-mm-yyyy");
supplierAttachment.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
supplierAttachment.ActionType = objsupplierInfo.ActionType;
supplierAttachment.UserCode = objsupplierInfo.UserCode;
}
foreach (SupplierContact supplierContact in objsupplierInfo.SupplierContactList_VW)
{
supplierContact.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
supplierContact.ActionType = objsupplierInfo.ActionType;
supplierContact.UserCode = objsupplierInfo.UserCode;
}
foreach (SupplierBusiness supplierBusiness in objsupplierInfo.SupplierBusinessList_VW)
{
supplierBusiness.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
supplierBusiness.ActionType = objsupplierInfo.ActionType;
supplierBusiness.UserCode = objsupplierInfo.UserCode;
}
string Vmsg = _supplierRepository.SaveSupplier(objsupplierInfo);
return(Ok(new
{
message = Vmsg
}));
}
public BusinessUsersController(IBusinessUsersLogic businessUsersLogic, BusinessUsersValidation businessUsersValidation, ICommonLogic commonLogic, CommonValidation commonValidation)
{
_businessUsersLogic = businessUsersLogic;
_businessUsersValidation = businessUsersValidation;
_commonLogic = commonLogic;
_commonValidation = commonValidation;
}
public AttendanceController(IAttendanceLogic attendanceLogic, AttendanceValidation attendanceValidation, ICommonLogic commonLogic, CommonValidation commonValidation)
{
this.attendanceValidation = attendanceValidation;
this.commonValidation = commonValidation;
this.commonLogic = commonLogic;
this.attendanceLogic = attendanceLogic;
}
public SalaryController(ISalaryLogic salaryLogic, SalaryValidation salaryValidation, ICommonLogic commonlogic, CommonValidation commonValidation)
{
_salaryLogic = salaryLogic;
_salaryValidation = salaryValidation;
_commonlogic = commonlogic;
_commonValidation = commonValidation;
}
public IActionResult SaveItemReceive(ItemReceive objItemReceive)
{
if (!String.IsNullOrEmpty(objItemReceive.ReceiveCode_PK))
{
objItemReceive.IsNew = false;
}
else
{
objItemReceive.IsNew = true;
}
objItemReceive.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
objItemReceive.IsReceived = 1;
foreach (ItemReceiveDet objItemReceiveDet in objItemReceive.ItemReceiveDet_VW)
{
objItemReceiveDet.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
objItemReceiveDet.ActionType = objItemReceive.ActionType;
objItemReceiveDet.UserCode = objItemReceive.UserCode;
objItemReceiveDet.CompanyCode_FK = objItemReceive.CompanyCode_FK;
}
string Vmsg = _itemReceiveRepository.SaveItemReceive(objItemReceive);
return(Ok(new
{
message = Vmsg
}));
}
public DeductionController(IDeductionLogic deductionLogic, DeductionValidation deductionValidation, ICommonLogic commonLogic, CommonValidation commonValidation)
{
_deductionLogic = deductionLogic;
_deductionValidation = deductionValidation;
_commonLogic = commonLogic;
_commonValidation = commonValidation;
}
public EmployeeController(IEmployeeLogic employeeLogic, EmployeeValidation employeeValidation, ICommonLogic commonLogic, CommonValidation commonValidation)
{
_employeeLogic = employeeLogic;
_employeeValidation = employeeValidation;
_commonLogic = commonLogic;
_commonValidation = commonValidation;
}
public IActionResult SavePurchaseRequsition(PurchaseRequisition objPMS_PurchaseRequisition)
{
string Vmsg = string.Empty;
objPMS_PurchaseRequisition.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
objPMS_PurchaseRequisition.RequisitionDate = CommonValidation.FormatDate(objPMS_PurchaseRequisition.RequisitionDate, "yyyy-mm-dd", "dd-mm-yyyy");
if (objPMS_PurchaseRequisition.PurchaseRequisitionItemList_VW.Count > 0)
{
foreach (PurchaseRequisitionItem objPurchaseRequisitionItem in objPMS_PurchaseRequisition.PurchaseRequisitionItemList_VW)
{
objPurchaseRequisitionItem.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
objPurchaseRequisitionItem.ActionType = objPMS_PurchaseRequisition.ActionType;
objPurchaseRequisitionItem.UserCode = objPMS_PurchaseRequisition.UserCode;
objPurchaseRequisitionItem.CompanyCode_FK = objPMS_PurchaseRequisition.CompanyCode_FK;
if (objPurchaseRequisitionItem.PurchaseReqItemSpecificationList_VW.Count > 0)
{
foreach (PurchaseReqItemSpecification purchaseReqItemSpecification in objPurchaseRequisitionItem.PurchaseReqItemSpecificationList_VW)
{
purchaseReqItemSpecification.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
purchaseReqItemSpecification.ActionType = objPMS_PurchaseRequisition.ActionType;
purchaseReqItemSpecification.UserCode = objPMS_PurchaseRequisition.UserCode;
purchaseReqItemSpecification.CompanyCode_FK = objPMS_PurchaseRequisition.CompanyCode_FK;
}
}
else
{
Vmsg = "Please enter product specfication!";
}
}
}
else
{
Vmsg = "Please enter product!";
}
if (objPMS_PurchaseRequisition.PurchaseRequisitionTermsList_VW.Count > 0)
{
foreach (PurchaseRequisitionCondition purchaseRequisitionCondition in objPMS_PurchaseRequisition.PurchaseRequisitionTermsList_VW)
{
purchaseRequisitionCondition.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
purchaseRequisitionCondition.ActionType = objPMS_PurchaseRequisition.ActionType;
purchaseRequisitionCondition.UserCode = objPMS_PurchaseRequisition.UserCode;
purchaseRequisitionCondition.CompanyCode_FK = objPMS_PurchaseRequisition.CompanyCode_FK;
}
}
else
{
Vmsg = "Please enter Terms and Condition!";
}
if (Vmsg == "")
{
Vmsg = _purchaseRequsitionRepository.SavePurchaseRequsition(objPMS_PurchaseRequisition);
}
return(Ok(new
{
message = Vmsg
}));
}
private void txtAge_KeyPress(object sender, KeyPressEventArgs e)
{
CommonValidation.IsNumberCheck(sender, e);
if (e.KeyChar == '\r')
{
cmbBloodGroup.Focus();
}
}
private void txtMobile_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == '\r')
{
txtNationality.Focus();
}
CommonValidation.IsNumberCheck(sender, e);
}
public void RaiseExceptionIfArgumentNull_GivenNullArgument_ShouldRaiseArgumentNullException()
{
// Arrange.
// Act.
// Assert.
Assert.Throws <ArgumentNullException>(
() => CommonValidation.RaiseExceptionIfArgumentNull(null, "SomeName"));
}
public DepartmentController(IDepartmentLogic departmentLogic, DepartmentValidations departmentValidations,
ICommonLogic commonLogic, CommonValidation commonValidation)
{
_departmentLogic = departmentLogic;
_departmentValidations = departmentValidations;
_commonLogic = commonLogic;
_commonValidation = commonValidation;
}
private void txtMobileContactPerson_KeyPress(object sender, KeyPressEventArgs e)
{
CommonValidation.IsNumberCheck(sender, e);
if (e.KeyChar == '\r')
{
cmbDoctorView.Focus();
}
}
public void RaiseExceptionIfArgumentNull_GivenNotNullArgument_ShouldNotRaiseException()
{
// Arrange.
// Act.
CommonValidation.RaiseExceptionIfArgumentNull("SomeValue", "SomeName");
// Assert.
Assert.Pass();
}
public IActionResult SaveRFPProcessing(RFProcessing objRFProcessing)
{
objRFProcessing.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
string Vmsg = _rfpprocessingrepository.SaveRFPProcessing(objRFProcessing);
return(Ok(new
{
message = Vmsg
}));
}
public void TestThatIsMailAddressReturnsTrueWhenValueIsMailAddress(string mailAddress)
{
var commonValidation = new CommonValidation();
Assert.That(commonValidation, Is.Not.Null);
var result = commonValidation.IsMailAddress(mailAddress);
Assert.That(result, Is.True);
}
public IActionResult SaveGeneralCodeFileType(GeneralCodeFileType objGeneralCodeFileType)
{
objGeneralCodeFileType.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
string Vmsg = _ICommonGeneralCodeFile.SaveGeneralCodeFileType(objGeneralCodeFileType);
return(Ok(new
{
message = Vmsg
}));
}
protected void Submit_Click(object sender, ImageClickEventArgs e)
{
if (CheckField())
{
try
{
string[] param = new string[26];
param[0] = "name";
param[1] = Name.Text;
param[2] = "ip";
param[3] = ClsConnection.StrIP;
param[4] = "UserId";
param[5] = ClsConnection.Userid;
param[6] = "mobile";
param[7] = txtMobile.Text;
param[8] = "email";
param[9] = txtEmailId.Text;
param[10] = "montlyincome";
param[11] = txtIncome.Text;
param[12] = "dob";
param[13] = txtDob.Text.Trim() != "" ? CommonValidation.GetYYYY_MM_DD(txtDob.Text) : "";
param[14] = "pan";
param[15] = txtPan.Text;
param[16] = "add1";
param[17] = txtAddress.Text;
param[18] = "cityid";
param[19] = ddlCity.SelectedValue;
param[20] = "stateid";
param[21] = ddlState.SelectedValue;
param[22] = "profession";
param[23] = ddlProfession.SelectedValue;
param[24] = "productid";
param[25] = ddlProduct.SelectedValue;
int rowaffected = CommanDataLoad.ExecuteNonQuery("Insert_Lead", "1", "", param);
if (rowaffected > 0)
{
Response.Write("<script>alert('Record Saved Successfully.');</script>");
// BindGrid();
}
//ClearControls();
//GridView1.DataBind();
}
catch (Exception ex)
{
lblmsg.Text = "Some Error" + ex.Message.ToString();
//Console.WriteLine("Some ERROR" + ex.Message.ToString());
}
}
}
public IActionResult GetRequisitionList(string requisitionDate)
{
string reqDate = CommonValidation.FormatDate(requisitionDate, "yyyy-mm-dd", "dd-mm-yyyy");
List <PurchaseRequisition> purchaseRequisitions = new List <PurchaseRequisition>();
purchaseRequisitions = _purchaseRequsitionRepository.GetRequisition(reqDate);
return(Ok(new
{
purchaseRequisitions
}));
}
public void TestThatIsMailAddressThrowsArgumentNullExceptionWhenValueIsInvalid(string invalidValue)
{
var commonValidation = new CommonValidation();
Assert.That(commonValidation, Is.Not.Null);
var exception = Assert.Throws <ArgumentNullException>(() => commonValidation.IsMailAddress(invalidValue));
Assert.That(exception, Is.Not.Null);
Assert.That(exception.ParamName, Is.Not.Null);
Assert.That(exception.ParamName, Is.Not.Empty);
Assert.That(exception.ParamName, Is.EqualTo("value"));
Assert.That(exception.InnerException, Is.Null);
}
public IActionResult SaveAppModuleObjectMapping(ListModel objList)
{
foreach (AppModuleObjectMapping objIApp in objList.objIAppModuleObjectMappingList)
{
objIApp.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
objIApp.ActionType = "INSERT";
}
string Vmsg = _appModuleObjectMapping.SaveMappedBusinessObject(objList.objIAppModuleObjectMappingList);
return(Ok(new
{
message = Vmsg
}));
}
private void txtDoctorFees_KeyPress(object sender, KeyPressEventArgs e)
{
if (!char.IsControl(e.KeyChar) && !char.IsDigit(e.KeyChar) && e.KeyChar != '.')
{
e.Handled = true;
}
// only allow one decimal point
if (e.KeyChar == '.' &&
(sender as TextBox).Text.IndexOf('.') > -1)
{
e.Handled = true;
}
CommonValidation.IsNumberCheck(sender, e);
}
public IActionResult SaveUploadedFiles(ListModel objList)
{
foreach (UploadedFile objUploadedFile in objList.objUploadedFiles)
{
objUploadedFile.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
}
string Vmsg = _uploadedFile.SaveUploadedFiles(objList.objUploadedFiles);
return(Ok(new
{
message = Vmsg
}));
}
/// <summary>
/// Check Validity of Attribute
/// </summary>
/// <param name="value">object value</param>
/// <param name="validationContext">validation Context</param>
/// <returns>Return Validation Result</returns>
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
if (value != null)
{
var uploadFile = value as HttpPostedFileBase;
var fileName = uploadFile.FileName;
byte[] fileContent = null;
var reader = new System.IO.BinaryReader(uploadFile.InputStream);
fileContent = reader.ReadBytes(uploadFile.ContentLength); ////Get file data byte array
return(CommonValidation.ValidateFileType(fileName, fileContent, Constants.MAXIMUM_FILE_UPLOAD_SIZE_BYTES, this.ValidExtensions) ? ValidationResult.Success : new ValidationResult(this.FormatErrorMessage(validationContext.DisplayName)));
}
return(ValidationResult.Success);
}
public IActionResult SaveProduct(Product objProduct)
{
if (!String.IsNullOrEmpty(objProduct.ProductCode_PK))
{
objProduct.IsNew = false;
}
else
{
objProduct.IsNew = true;
}
objProduct.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
string Vmsg = _product.SaveProduct(objProduct);
return(Ok(new
{
message = Vmsg
}));
}
