public void BindASCBranchPlant(Label lblBranchPlantName)
{
SqlParameter[] sqlParam =
{
new SqlParameter("@Type", "SELECT_BRANCH_PLANT"),
new SqlParameter("@ASC_Id", this.ASC_Id)
};
lblBranchPlantName.Text = Convert.ToString(objSql.ExecuteScalar(CommandType.StoredProcedure, "uspSpareRequirementIndentConfirm", sqlParam));
sqlParam = null;
}
public string GET_DRAFT_NO()
{
SqlParameter[] sqlParamG =
{
new SqlParameter("@Type", "GET_DRAFT_NO")
};
string strUNIQUEKEY = "";
strUNIQUEKEY = Convert.ToString(objSql.ExecuteScalar(CommandType.StoredProcedure, "uspSpareRequirementIndent", sqlParamG));
return(strUNIQUEKEY);
}
public string GET_UNIQUE_KEY_VALUE(string strASC_Code)
{
SqlParameter[] sqlParamG =
{
new SqlParameter("@Type", "GET_UNIQUE_KEY_VALUE"),
new SqlParameter("@COLUMNNAME", "Transaction_No"),
new SqlParameter("@ASC_Id", strASC_Code)
};
string strUNIQUEKEY = "";
strUNIQUEKEY = Convert.ToString(objSql.ExecuteScalar(CommandType.StoredProcedure, "uspSalesOrderReceipts", sqlParamG));
return(strUNIQUEKEY);
}
public string GetFinalPDSTransactionNo()
{
SqlParameter sqlParam = new SqlParameter("@Type", "GET_FINAL_PDS_TRANSACTION_NO");
string strReturn = Convert.ToString(objSql.ExecuteScalar(CommandType.StoredProcedure, "uspDeliverySchedule", sqlParam));
sqlParam = null;
return(strReturn);
}
public string GetAutoGeneratedNumber()
{
string AutoGeneratedNumber = string.Empty;
SqlParameter[] param =
{
new SqlParameter("@Type", "GET_AUTOGENERATED_NUMBER"),
new SqlParameter("@PrefixString", this.PrefixString)
};
AutoGeneratedNumber = Convert.ToString(objSql.ExecuteScalar(CommandType.StoredProcedure, "uspSparePurchaseOutside", param));
return(AutoGeneratedNumber);
}
public string GetBranchPlant(string strAsc_Id)
{
string strReturn = "";
SqlParameter[] sqlParam =
{
new SqlParameter("@Type", "SELECT_ASC_BRANCH_PLANT"),
new SqlParameter("@ASC_Id", strAsc_Id)
};
strReturn = Convert.ToString(objSql.ExecuteScalar(CommandType.StoredProcedure, "uspASCSpecificSpareMaster", sqlParam));
sqlParam = null;
return(strReturn);
}
public int CheckLoogedInASC()
{
SIMSSqlDataAccessLayer objSIMSSqlDataAccessLayer = new SIMSSqlDataAccessLayer();
SqlParameter[] param =
{
new SqlParameter("@Type", "CHECK_LOGGED_IN_ASC"),
new SqlParameter("@UserName", this.EmpId)
};
int RecCount = 0;
RecCount = Convert.ToInt32(objSIMSSqlDataAccessLayer.ExecuteScalar(CommandType.StoredProcedure, "uspSIMSCommonMISFunctions", param));
return(RecCount);
}
public bool AdviceAllreadyGenerated()
{
bool blnAdviceAllreadyGenerated = false;
SqlParameter[] sqlParamS =
{
new SqlParameter("@Complaint_No", this.Complaint_No),
new SqlParameter("@SpareId", this.Adviced_Spare_Id),
new SqlParameter("@Type", "CHECK_ADVICE_ALLREADY_GENERATED")
};
int RecCount = Convert.ToInt32(objSql.ExecuteScalar(CommandType.StoredProcedure, "uspSpareConsumeForComplaint", sqlParamS));
if (RecCount > 0)
{
blnAdviceAllreadyGenerated = true;
}
sqlParamS = null;
return(blnAdviceAllreadyGenerated);
}