public IList <MobileVersion> GetMobileVersion(MobileVersion mobileversion)
{
//string fetchMobileVersionType = $"SELECT * FROM Mobifix_DB.MOBILE_VER_TYPE WHERE LOWER (MOBILE_VER_TYPE_ID) = '{ mobileversion.MobileVersionTypeID.ToString() }'";
string fetchMobileVersionType = $"SELECT * FROM Mobifix_DB.MOBILE_VER_TYPE WHERE LOWER (FK_MOBILE_CMPNY_ID) = '{mobileversion.MobileCompanyID}'";
var dtResult = MySqlMobileVersionHelper.ExecuteQuery(fetchMobileVersionType);
var mobileversiontype = FillMobileVersionTypesModel(dtResult);
return(mobileversiontype);
}
public IHttpActionResult GetMobileVersion([FromBody] MobileVersion mobileversion)
{
var moblieversionRepo = new MobileVersionRepository();
var getmobileversiontype = moblieversionRepo.GetMobileVersion(mobileversion);
if (getmobileversiontype == null)
{
return(NotFound());
}
return(Ok(getmobileversiontype));
}
public IHttpActionResult UpdateMobileVersion([FromBody] MobileVersion mobileversion)
{
var mobileversionRepo = new MobileVersionRepository();
var result = mobileversionRepo.UpdateMobileVersion(mobileversion);
if (result <= 0)
{
return(Ok("Error occurred while updating Mobile Version Status"));
}
return(Ok("Mobile version description updated"));
}
public MobileVersion Create(MobileVersion mobileVersion)
{
try
{
_mobileVersion.InsertOne(mobileVersion);
return(mobileVersion);
}
catch (Exception ex)
{
_logger.LogError(ex, ex.Message);
return(null);
}
}
public MobileVersion GetMobileVersion(string type, string version)
{
var objMobileVersion = new MobileVersion();
try
{
objMobileVersion = _mobileVersion.Find(m => m.Type.ToLower() == type.ToLower() && m.Version == version).FirstOrDefault();
}
catch (Exception ex)
{
_logger.LogError(ex, ex.Message);
}
return(objMobileVersion);
}
private IList <MobileVersion> FillMobileVersionTypesModel(DataTable dtMobileVersion)
{
var mobileversiontypesList = new List <MobileVersion>();
if (null != dtMobileVersion && dtMobileVersion.Rows.Count > 0)
{
foreach (DataRow row in dtMobileVersion.Rows)
{
var mobileversiontype = new MobileVersion();
mobileversiontype.MobileVersionTypeID = Convert.ToInt32(row["MOBILE_VER_TYPE_ID"]);
//mobileversiontype.MobileCompanyID = Convert.ToInt32(row["MOBILE_CMPNY_ID"]);
mobileversiontype.MobileVersionDescription = Convert.ToString(row["MOBILE_VER_DESC"]);
// mobileversiontype.MobileVersionTypeID = Convert.ToInt32(row["MOBILE_VER_TYPE_IND"]);
mobileversiontype.CreatedDate = Convert.ToDateTime(row["CREATED_DATE"]);
mobileversiontype.CreatedBy = Convert.ToInt32(row["CREATED_BY"]);
mobileversiontypesList.Add(mobileversiontype);
}
}
return(mobileversiontypesList);
}
public ProductManager(string MobilePath, MobileVersion Version)
{
this.MobilePath = MobilePath;
this.Version = Version;
}
public int UpdateMobileVersion(MobileVersion mobileversion)
{
string updateMobileVersion = $"UPDATE Mobifix_DB.MOBILE_VER_TYPE SET MOBILE_VER_DESC = '{mobileversion.MobileVersionDescription}' WHERE LOWER(MOBILE_VER_TYPE_ID) = '{mobileversion.MobileVersionTypeID.ToString()}' ";
return(MySqlMobileVersionHelper.ExecuteNonQuery(updateMobileVersion));
}
public MobileResourceManager(string MobilePath, MobileVersion Version)
{
this.MobilePath = MobilePath;
this.Version = Version;
}
public ProductManager(string MobilePath, MobileVersion Version)
{
this.MobilePath = MobilePath;
this.Version = Version;
}
public MobileResourceManager(string MobilePath, MobileVersion Version)
{
this.MobilePath = MobilePath;
this.Version = Version;
}
