/// <summary>
///
/// </summary>
/// <param name="objSetSKUMetadataRequest"></param>
/// <param name="objSetSKUMetadataResponse"></param>
/// <returns></returns>
public bool ProcessRequest(SetSKUMetadataRequest objSetSKUMetadataRequest, SetSKUMetadataResponse objSetSKUMetadataResponse)
{
bool flag = false;
string statusMsg = string.Empty;
try
{
#region codestart
DataSet ds = new DataSet();
if (objSetSKUMetadataRequest.SKUMetadata.SKUID != null)
{
statusMsg = SetSKUMetadata(objSetSKUMetadataRequest);
}
if ((!string.IsNullOrEmpty(statusMsg)) && (statusMsg.Contains("Record already exists") || statusMsg.Contains("No record exists")))
{
objSetSKUMetadataResponse.ResponseStatus = 1;
objSetSKUMetadataResponse.ResponseMessage = statusMsg;
flag = false;
}
else
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.Success;
objSetSKUMetadataResponse.ResponseMessage = statusMsg;
flag = true;
}
#endregion
}
catch (Exception ex)
{
throw new Exception("Error Occured While getting the output of ProcessRequest method related to SetSKUMetadata. " + ex.Message + Environment.NewLine + ex.StackTrace);
}
return(flag);
}
/// <summary>
///
/// </summary>
/// <param name="objSetSoftwareMetadataRequest"></param>
/// <returns></returns>
public SetSKUMetadataResponse SetSKUMetadata(SetSKUMetadataRequest objSetSKUMetadataRequest)
{
var objSetSKUMetadataResponse = new SetSKUMetadataResponse();
objSetSKUMetadataResponse.RequestID = objSetSKUMetadataRequest.RequestID;
objSetSKUMetadataResponse.ResponseID = objSetSKUMetadataRequest.RequestID;
objSetSKUMetadataResponse.ResponseDateTime = DateTime.UtcNow;
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.NotImplemented;
objSetSKUMetadataResponse.ResponseMessage = Constants.ResponseStatus.NotImplemented.ToString();
try
{
//ASSIGNING ID'S
objSetSKUMetadataResponse.RequestID = objSetSKUMetadataRequest.RequestID;
objSetSKUMetadataResponse.ResponseID = objSetSKUMetadataRequest.RequestID;
//INPUT DATA VALIDATION
if (objSetSKUMetadataBL.ValidateRequest(objSetSKUMetadataRequest, objSetSKUMetadataResponse))
{
//PROCESS DATA & RETURN RESPONSE
objSetSKUMetadataBL.ProcessRequest(objSetSKUMetadataRequest, objSetSKUMetadataResponse);
}
}
catch (Exception ex)
{
//SET FAILURE STATUS
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.ServiceUnavailable;
objSetSKUMetadataResponse.ResponseMessage = Constants.ResponseMessage[1000].ToString();
//LOG EXCEPTION
objEventLogger.WriteLog(ex.Message + Environment.NewLine + ex.StackTrace, objSetSKUMetadataRequest.RequestingSystem, DateTime.UtcNow, objSetSKUMetadataRequest.RequestID);
}
finally
{
objSetSKUMetadataResponse.ResponseDateTime = DateTime.UtcNow;
//SERIALIZE REQUEST/RESPONSE
string request = "SetSKUMetadataRequest";
string response = "SetSKUMetadataResponse";
try
{
request = Util.SerializeObject(objSetSKUMetadataRequest);
response = Util.SerializeObject(objSetSKUMetadataResponse);
}
catch (Exception ex)
{
objEventLogger.WriteLog("Request/Response Object Serialization Error: " + ex.Message + Environment.NewLine + ex.StackTrace, objSetSKUMetadataRequest.RequestingSystem, DateTime.UtcNow, objSetSKUMetadataRequest.RequestID);
}
if (!request.IsValidString())
{
request = "SetSKUMetadataRequest";
}
if (!response.IsValidString())
{
response = "SetSKUMetadataResponse";
}
//LOG REQUEST/RESPONSE
objTransactionLogger.LogTransaction(objSetSKUMetadataRequest.RequestID, objSetSKUMetadataRequest.RequestDateTime, objSetSKUMetadataRequest.RequestingSystem,
request, objSetSKUMetadataResponse.ResponseID, objSetSKUMetadataResponse.ResponseDateTime, response,
objSetSKUMetadataResponse.ResponseStatus, objSetSKUMetadataResponse.ResponseMessage, 0);
//End Processing SetSKUMetadata
}
//SetSKUMetadata ends
return(objSetSKUMetadataResponse);
//return resp;
}
/// <summary>
///
/// </summary>
/// <param name="objSetSKUMetadataRequest"></param>
/// <param name="objSetSKUMetadataResponse"></param>
/// <returns></returns>
public bool ValidateRequest(SetSKUMetadataRequest objSetSKUMetadataRequest, SetSKUMetadataResponse objSetSKUMetadataResponse)
{
bool ValidationStatus = true;
string strAlgIDs = ConfigurationSettings.AppSettings["Algorithms"];
List <string> lstAlgIds = new List <string>(strAlgIDs.Split(','));
if (!objSetSKUMetadataRequest.RequestID.IsValidString() && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = Constants.ResponseStatus.InvalidParameter.ToString();
ValidationStatus = false;
}
if (!objSetSKUMetadataRequest.RequestingSystem.IsValidString() && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = Constants.ResponseStatus.InvalidParameter.ToString();
ValidationStatus = false;
}
if (objCommonValidationBL.DupCheckRequestId(objSetSKUMetadataRequest.RequestID, objSetSKUMetadataRequest.RequestingSystem) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.AmbigousRequest;
objSetSKUMetadataResponse.ResponseMessage = Constants.ResponseMessage[3].ToString();
ValidationStatus = false;
}
if (((objSetSKUMetadataRequest.SKUMetadata.SKUID == null) || (objSetSKUMetadataRequest.SKUMetadata.SKUID != null && !objSetSKUMetadataRequest.SKUMetadata.SKUID.IsValidString())) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.UnKnownSKU;
/*Bug no:4397 */
objSetSKUMetadataResponse.ResponseMessage = "SKU element is required. Please enter valid SKU";//"Please enter valid SKU";
ValidationStatus = false;
}
if ((objSetSKUMetadataRequest.SKUMetadata.SKUID != null) && ValidationStatus)
{
if (objSetSKUMetadataRequest.SKUMetadata.SKUID.Trim().ToLower().Equals("null"))
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.UnKnownSKU;
objSetSKUMetadataResponse.ResponseMessage = "SKUID cannot be 'NULL'.Please enter valid SKUID";
ValidationStatus = false;
}
}
if (objSetSKUMetadataRequest.SKUMetadata.ActionType == null && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Please enter valid Action Type";
ValidationStatus = false;
}
if (objSetSKUMetadataRequest.SKUMetadata.ActionType != null && ValidationStatus)
{
if (!(objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("insert") || objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("update") || objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("delete")))
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Invalid ActionType. Valid Action Type(s) are : insert or Update or Delete";
ValidationStatus = false;
}
}
if (objSetSKUMetadataRequest.SKUMetadata.ActionType != null)
{
if ((objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("insert") || objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("update")) && ValidationStatus)
{
if ((objSetSKUMetadataRequest.SKUMetadata.AlgID == null || (objSetSKUMetadataRequest.SKUMetadata.AlgID != null && !objSetSKUMetadataRequest.SKUMetadata.AlgID.IsValidString())) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
/*Bug no:4397 */
objSetSKUMetadataResponse.ResponseMessage = "Alg. ID element is required. Please enter valid Alg. ID";//"Invalid Alg ID";
ValidationStatus = false;
}
if (objSetSKUMetadataRequest.SKUMetadata.AlgID != null && ValidationStatus)
{
if (objSetSKUMetadataRequest.SKUMetadata.AlgID.Trim().ToLower().Equals("null"))
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "AlgID cannot be 'NULL'.Please enter proper value.";
ValidationStatus = false;
}
else if (!lstAlgIds.Contains(objSetSKUMetadataRequest.SKUMetadata.AlgID))
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Not valid AlgID.AlgID Should be one among the range " + strAlgIDs;
ValidationStatus = false;
}
}
if ((objSetSKUMetadataRequest.SKUMetadata.Seed == null || (objSetSKUMetadataRequest.SKUMetadata.Seed != null && !objSetSKUMetadataRequest.SKUMetadata.Seed.IsValidString())) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
/*Bug no:4397 */
objSetSKUMetadataResponse.ResponseMessage = "Seed element is required. Please enter valid Seed";//"Invalid seed";
ValidationStatus = false;
}
if (objSetSKUMetadataRequest.SKUMetadata.Seed != null && ValidationStatus)
{
if (objSetSKUMetadataRequest.SKUMetadata.Seed.Trim().ToLower().Equals("null"))
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Seed cannot be 'NULL'.Please enter proper value.";
ValidationStatus = false;
}
}
}
}
if (objSetSKUMetadataRequest.SKUMetadata.ProductType != null && ValidationStatus)
{
if (!(objSetSKUMetadataRequest.SKUMetadata.ProductType.Equals(1) || objSetSKUMetadataRequest.SKUMetadata.ProductType.Equals(2)))
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Invalid ProductType.Please enter either 1 or 2";
ValidationStatus = false;
}
if ((objSetSKUMetadataRequest.SKUMetadata.ProductType.Equals(2) && objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "SW cannot have a product type of 2.Please change the ProductType or uncheck the SoftwareMetadata";
ValidationStatus = false;
}
if ((objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("insert") || objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("update")) && ValidationStatus)
{
if ((objSetSKUMetadataRequest.SKUMetadata.ProductType.Equals(1) && objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata == null) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "SW should have SoftwareMetadata.";
ValidationStatus = false;
//We cannot have a SW without Version metadata
}
}
}
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null && ValidationStatus)
{
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.Version == null && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Please enter valid Version";
ValidationStatus = false;
}
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionType == null && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Please enter valid VersionType";
ValidationStatus = false;
}
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionSeqNo == null && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Please enter valid VersionSeqNo";
ValidationStatus = false;
}
if ((objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.Version != null && objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.Version.Trim().ToLower().Equals("null")) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "Version cannot be 'NULL'.Please enter proper value.";
ValidationStatus = false;
}
if ((objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionType != null && objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionType.Trim().ToLower().Equals("null")) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "VersionType cannot be 'NULL'.Please enter proper value.";
ValidationStatus = false;
}
if ((objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionSeqNo != null && objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionSeqNo.ToString().ToLower().Equals("null")) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "VersionSeqNo cannot be 'NULL'.Please enter proper int value.";
ValidationStatus = false;
}
if ((objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionReleaseClassification != null && objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionReleaseClassification.Trim().ToLower().Equals("null")) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
objSetSKUMetadataResponse.ResponseMessage = "VersionReleaseClassification cannot be 'NULL'.Please enter proper value.";
ValidationStatus = false;
}
}
if (objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("insert") && ValidationStatus)
{
if (((objSetSKUMetadataRequest.SKUMetadata.CreatedBy == null) || (objSetSKUMetadataRequest.SKUMetadata.CreatedBy != null && !objSetSKUMetadataRequest.SKUMetadata.CreatedBy.IsValidString())) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
/*Bug no:4397 */
objSetSKUMetadataResponse.ResponseMessage = "CreatedBy element is required. Please enter valid user id for CreatedBy";//"Please enter valid user id for CreatedBy";
ValidationStatus = false;
}
if (((objSetSKUMetadataRequest.SKUMetadata.UpdatedBy == null) || (objSetSKUMetadataRequest.SKUMetadata.UpdatedBy != null && !objSetSKUMetadataRequest.SKUMetadata.UpdatedBy.IsValidString())) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
/*Bug no:4397 */
objSetSKUMetadataResponse.ResponseMessage = "UpdatedBy element is required. Please enter valid user id for UpdatedBy";//"Please enter valid user id for UpdatedBy";
ValidationStatus = false;
}
}
if ((objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("update") || objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("delete")) && ValidationStatus)
{
if (((objSetSKUMetadataRequest.SKUMetadata.UpdatedBy == null) || (objSetSKUMetadataRequest.SKUMetadata.UpdatedBy != null && !objSetSKUMetadataRequest.SKUMetadata.UpdatedBy.IsValidString())) && ValidationStatus)
{
objSetSKUMetadataResponse.ResponseStatus = (int)Constants.ResponseStatus.InvalidParameter;
/*Bug no:4397 */
objSetSKUMetadataResponse.ResponseMessage = "UpdatedBy element is required. Please enter valid user id for UpdatedBy";//"Please enter valid user id for UpdatedBy";
ValidationStatus = false;
}
}
return(ValidationStatus);
}
/// <summary>
/// This method sets the input parameters and calls the SP to perform the insert/delete/update operations
/// </summary>
/// <param name="objSetSKUMetadataRequest"></param>
/// <returns></returns>
private string SetSKUMetadata(SetSKUMetadataRequest objSetSKUMetadataRequest)
{
string statusMsg = string.Empty;
//bool status = true;
using (SqlConnection objCon = new SqlConnection(connectionString))
{
SqlParameter[] arParms = new SqlParameter[24];
arParms[0] = new SqlParameter("@ActionType", SqlDbType.VarChar, 100);
arParms[0].Value = objSetSKUMetadataRequest.SKUMetadata.ActionType;
arParms[0].Direction = ParameterDirection.Input;
arParms[1] = new SqlParameter("@SKUID", SqlDbType.VarChar, 100);
arParms[1].Value = objSetSKUMetadataRequest.SKUMetadata.SKUID;
arParms[1].Direction = ParameterDirection.Input;
arParms[2] = new SqlParameter("@TAASysPartNo", SqlDbType.VarChar, 100);
arParms[2].Value = objSetSKUMetadataRequest.SKUMetadata.TAASysPartNo;
arParms[2].Direction = ParameterDirection.Input;
arParms[3] = new SqlParameter("@TAASysPartName", SqlDbType.VarChar, 100);
arParms[3].Value = objSetSKUMetadataRequest.SKUMetadata.TAASysPartName;
arParms[3].Direction = ParameterDirection.Input;
arParms[4] = new SqlParameter("@TAAPartNo", SqlDbType.VarChar, 100);
arParms[4].Value = objSetSKUMetadataRequest.SKUMetadata.TAAPartNo;
arParms[4].Direction = ParameterDirection.Input;
arParms[5] = new SqlParameter("@TAAPartName", SqlDbType.VarChar, 100);
arParms[5].Value = objSetSKUMetadataRequest.SKUMetadata.TAAPartName;;
arParms[5].Direction = ParameterDirection.Input;
arParms[6] = new SqlParameter("@ProductType", SqlDbType.Int);
arParms[6].Value = objSetSKUMetadataRequest.SKUMetadata.ProductType;
arParms[6].Direction = ParameterDirection.Input;
arParms[7] = new SqlParameter("@Qty", SqlDbType.Int);
arParms[7].Value = objSetSKUMetadataRequest.SKUMetadata.Qty;
arParms[7].Direction = ParameterDirection.Input;
arParms[8] = new SqlParameter("@AlgID", SqlDbType.VarChar, 100);
if (objSetSKUMetadataRequest.SKUMetadata.AlgID == null && objSetSKUMetadataRequest.SKUMetadata.ActionType.Trim().ToLower().Equals("delete"))
{
arParms[8].Value = "0";
}
else
{
arParms[8].Value = objSetSKUMetadataRequest.SKUMetadata.AlgID;
}
arParms[8].Direction = ParameterDirection.Input;
arParms[9] = new SqlParameter("@AlgDesc", SqlDbType.VarChar, 100);
arParms[9].Value = objSetSKUMetadataRequest.SKUMetadata.AlgDesc;
arParms[9].Direction = ParameterDirection.Input;
arParms[10] = new SqlParameter("@Seed", SqlDbType.VarChar, 100);
arParms[10].Value = objSetSKUMetadataRequest.SKUMetadata.Seed;
arParms[10].Direction = ParameterDirection.Input;
arParms[11] = new SqlParameter("@TaaType", SqlDbType.VarChar, 100);
arParms[11].Value = objSetSKUMetadataRequest.SKUMetadata.TaaType;
arParms[11].Direction = ParameterDirection.Input;
arParms[12] = new SqlParameter("@AllowMany", SqlDbType.Int);
arParms[12].Value = objSetSKUMetadataRequest.SKUMetadata.AllowMany;
arParms[12].Direction = ParameterDirection.Input;
arParms[13] = new SqlParameter("@Version", SqlDbType.VarChar, 100);
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null)
{
arParms[13].Value = objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.Version;
}
else
{
arParms[13].Value = string.Empty;
}
arParms[13].Direction = ParameterDirection.Input;
arParms[14] = new SqlParameter("@VersionType", SqlDbType.VarChar, 100);
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null)
{
arParms[14].Value = objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionType;
}
else
{
arParms[14].Value = string.Empty;
}
arParms[14].Direction = ParameterDirection.Input;
arParms[15] = new SqlParameter("@VersionSeqNo", SqlDbType.Int);
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null)
{
arParms[15].Value = objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionSeqNo;
}
else
{
arParms[15].Value = 0;
}
arParms[15].Direction = ParameterDirection.Input;
arParms[16] = new SqlParameter("@VersionReleaseClassification", SqlDbType.VarChar, 100);
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null)
{
arParms[16].Value = objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.VersionReleaseClassification;
}
else
{
arParms[16].Value = string.Empty;
}
arParms[16].Direction = ParameterDirection.Input;
arParms[17] = new SqlParameter("@ImageUrl", SqlDbType.VarChar, 100);
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null)
{
arParms[17].Value = objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.ImageUrl;
}
else
{
arParms[17].Value = string.Empty;
}
arParms[17].Direction = ParameterDirection.Input;
arParms[18] = new SqlParameter("@ReleaseDate", SqlDbType.DateTime, 100);
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata != null)
{
//arParms[18].Value = objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.ReleaseDate;
if (objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.ReleaseDate.ToString().Equals("1/1/0001 12:00:00 AM"))
{
arParms[18].Value = null;
}
else
{
arParms[18].Value = objSetSKUMetadataRequest.SKUMetadata.SoftwareMetadata.ReleaseDate;
}
}
else
{
arParms[18].Value = null;
}
arParms[18].Direction = ParameterDirection.Input;
arParms[19] = new SqlParameter("@CreatedBy", SqlDbType.VarChar, 100);
if (objSetSKUMetadataRequest.SKUMetadata.CreatedBy != null)
{
arParms[19].Value = objSetSKUMetadataRequest.SKUMetadata.CreatedBy;
}
else
{
arParms[19].Value = "SWIFT";
}
arParms[19].Direction = ParameterDirection.Input;
arParms[20] = new SqlParameter("@CreatedOn", SqlDbType.VarChar, 100);
arParms[20].Value = objSetSKUMetadataRequest.SKUMetadata.CreatedOn;
arParms[20].Direction = ParameterDirection.Input;
arParms[21] = new SqlParameter("@UpdatedBy", SqlDbType.VarChar, 100);
if (objSetSKUMetadataRequest.SKUMetadata.UpdatedBy != null)
{
arParms[21].Value = objSetSKUMetadataRequest.SKUMetadata.UpdatedBy;
}
else
{
arParms[21].Value = "SWIFT";
}
arParms[21].Direction = ParameterDirection.Input;
arParms[22] = new SqlParameter("@UpdatedOn", SqlDbType.VarChar, 100);
arParms[22].Value = objSetSKUMetadataRequest.SKUMetadata.UpdatedOn;
arParms[22].Direction = ParameterDirection.Input;
arParms[23] = new SqlParameter("@ErrorMessage", SqlDbType.VarChar, 200);
arParms[23].Direction = ParameterDirection.Output;
using (SqlCommand objCMD = new SqlCommand("pTAA_SetSKUMetadata", objCon))
{
objCon.Open();
objCMD.CommandType = CommandType.StoredProcedure;
objCMD.Connection = objCon;
objCMD.Parameters.AddRange(arParms);
objCMD.ExecuteNonQuery();
}
statusMsg = arParms[23].Value.ToString();
}
return(statusMsg);
}
public override SetSKUMetadataResponse SetSKUMetadata(SetSKUMetadataRequest objSetSKUMetadataRequest)
{
SetSKUMetadataProcess objSetSKUMetadataProcess = new SetSKUMetadataProcess();
return(objSetSKUMetadataProcess.SetSKUMetadata(objSetSKUMetadataRequest));
}
